Only measuring the "latest" values
What’s in a measure? All too often, we limit ourselves needlessly when we equate measures, metrics, or aggrega...
Forum Posts
[Analytic Block] - Pivot by Top X - Introducing bind_all_filters: yes
Pivot by Top 10 You’ve got a high cardinality dimension and you’d love to just see the Top 10 based on some me...
Readable times from seconds
It’s often times useful to get a neatly displayed readable times. Typically this isn’t a problem, but if we wa...
End-user-defined dynamic tiers
Looker’s tier dimension type is great for defining buckets for breaking out numeric dimensions. For example, h...
Dimension_group w/ type "time" doesn't work with datatype: datetime for BigQuery
Consider the following code: view: datetime { derived_table: { sql: SELECT CURRENT_DATETIME as dt;; # Bigquery...
_TABLE_SUFFIX between
Hi, I would like to choose specific start_date and end_date by a filter as where condition. SQL I used - {CALE...
Creating Dynamic Tiers
The content of this article has been updated and migrated to a Looker Help Center article. But, the informatio...
List Of Values
Hi Could anyone please tell me how we can assign a list of values (either static values or through custom SQL)...
Parsing user agent into device_type, manufacturer, browser
I’m currently using a fairly rudimentary case statement to parse useragent strings into ‘device_type’ (see bel...