Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
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 is why we add the +1 so that it start at 1 instead
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_index(${orders.count},1) And then hide the original measure. Now in my visualization only the cancelled count table calc will show
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 change the background color of its values : dimension: status{ description: "this is my description" type:string sql:${TABLE}.status;; html:{% if value == 'cancelled' %} <p style="color: black; background-color: lightblue; font-size:100%; text-align:center">{{ rendered_value }}</p> {% elsif value == 'pending' %} <p style="color: black; background-color: lightgreen; font-size:100%; text-align:center">{{ rendered_value }}</p> {% else %} <p style="color: black; background-color: orange; font-size:100%; text-align:center">{{ rendered_value }}</p> {% endif %} ;; }
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
