This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’ve had a few people ask how to do a reverse rank and I’ve found the
best way to do so is by using something like :
max(row())-rank(${order_items.count}, ${order_items.count})+1 where the
max() is going to return a reverse rank starting with 0 which...
Hi all, I would recommend hiding columns under a pivot by using the
pivot_index() to select the columns you want to show. So for example, if
I want to only SHOW the count measure under the cancelled pivoted value
: i can create a table calc pivot_ind...
Hi Hwi, I’m thinking we could use the the html parameter in your lookml
dimension in order to change the background color based on your values
(as mentioned in this help article). For example, if I have a field
called Status I can conditionally chang<!-- --><!-- --><!-- -->...