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.
There are many reasons to come up with a document that explains what
fields/explores/models are available or exposed in our Looker
application. This script is used to parse through the model definition
and print out a csv of fields. I use the Looker <!-- --><!-- --><!-- -->...
Waterfall charts are a good way to show how many parts can compose one
final number Such as how revenue, minus expenses will create net profit.
Here is how to create one of these charts in Looker, starting with some
profit and loss data: When modelin...
Looking for some of the best practices we follow when building in
LookML? Here are some helpful tips: Naming Convention Follow Looker
naming conventions: Name measures with aggregate function or common
terms. total_[FIELD] for sum, count_[FIELD], avg...
April 2016 Update: You can also add an “Other” bucket [using Table
Calculations]
https://community.looker.com/technical-tips-tricks-1021/creating-a-pie-chart-with-over-50-rows-using-table-calcs-to-create-an-other-bucket-25790It
is common to have a fe...
The content of this article has been updated and migrated to a Looker
Help Center article. But, the information in the comments is useful, so
the article will remain here for discussion. For the actual contents,
please visit the Help Center.
Jason, That is just a simple running_total table calculation and divide
that by the sum of the whole column: You can use percent_0 as the format
or a custom format as shown in the image. The calculation is here:
running_total(${order_details.total_re...
It is a lot being done post query, which could impact performance a bit.
Perhaps combining some of the calculations could work. If you have
developer access, I would definitely move the Income, Expense and Total
columns into measures and dimensions a...
You are right, what if we run a loss? The method above would end up
looking like this: Not so great! To fix this I broke up my expense
column into two columns: a positive and a negative. It’s not super
pretty, but it works. Here are my new calculatio...
Rick, As of the current build of Looker, we have no recommendations for
more than three options. I’ll happily share this with our product team
to see if its possible to expand this.