Make use of filter operator (is equal to, contains, etc.) within Liquid statement
Hi Liquid variables are quite powerful and really useful. Is there and way to get the filter operator (is equa...
Modeling
Building a healthy project - and keeping it that way. Share your stumpers and successes with data management, performance optimization, SQL, LookML, caching, and more.
Forum Posts
Using Postgres and JSON Functions and Operators to parse JSON fields
Any SQL functionality that is native to your dialect can be leveraged in the sql: parameters within LookML, or...
Metadata and explores
Hi I’m after a way to list all the fields - dimensions and measures - exposed (not hidden) in all explores in ...
MEASURES AND DATE FILTERING
I have a formula where I have to first find the max and min dates within a month against the data, then use th...
Custom Measure based on logical OR of 4 dimensions in table
I am working with a table which has 4 related dimensions (let’s say A,B,C,D) any of which may be not null. Now...
Auto Populate allowed_value: in Parameter/Filter-Only Field
Is it possible to query a table, and load all the results from one of the columns into the allowed values of a...
Postgres (P)DT Performance Tip
I’m currently working with a client where Postgres is used as the data warehouse DB. One of Postgres’ features...
Measure filters not working with more than one "-Negative" Filters
measure: total_gross_revenue { type: sum sql: ${amount};; filters: [invoice_item_types.name: "-CREDIT_TYPE", i...
Auto Delete PDTs
I’m using persist_for and sql_trigger_value to create PDTs for some complex queries in TeraData. But enabling ...
Arbitrary Period Comparisons
Google Analytics has a date selector that allows for comparison of two arbitrary time periods on the same char...
Where datagroups live
I’m trying to update https://github.com/ww-tech/lookml-tools's linter. I’m coming across datagroups for the fi...
Help With Templated Filter and Liquid
Hi All, I’m trying to create a derived table that lets me input a date and pull value from 7 days prior to tha...
UTC date and hour data to different timezone based report
Need help with converting UTC date partitioned data into a different timezone based data/report. | date (DATE)...
Week of Month in Month over Month
Is it possible to use the timeframe to create a week_of_month like a week_of_year? I need to show a graph of M...
need date range to sort as per dates not string
I need to showcase a date range (start date - end date) (as a dimension) in the format ‘Month Day, Year’, and ...
Dimension using GROUP BY from View
Hi all, I have a view: my_app { … dimension: time { #… } dimension: device_id { #… } dimension: todo { # SELEC...
Set up Flexible Retention Analysis without Derived Tables
Retention is a metric to understand how many users return to your platform after the initial conversion. Reten...
Set cache for calendar month based reports?
A lot of the reports generated by our Looker system have a whole calendar month time filter Is there a way to ...
How to Use ThetaSketch for COUNT DISTINCT on Druid?
When we are trying to do COUNT DISTINCT, it reports Remote driver error: QueryInterruptedException: Incompatib...
ASK: Filter Boolean on Measure
Hi, I have issue with creating measure on a view. When put into explore, the query doesn’t run because the fil...
ASK: New To Looker - LookML Model Query Cost Optimization Tips & Tricks
Hi All, I’m very very new to looker, excited to be part of the community and learn from you all. Would be grea...
add_days produces erroring DATEADD
I’m trying to add a custom dimension to bucket days by groups of three and still have the column values be dat...
Dimension/Measure/Parameter Naming Conventions
Can anyone share some pros & cons for using CamelCase vs lower_case for naming Dimensions, Measures, and Param...
SQL runner search function change
Hi all, Our search function in SQL runner has changed from: to: The problem is that before when entering value...
"fields:" Parameter Misbehaving
I have this very simple scenario. Here is the View: view: Customer { sql_table_name: "DBO"."CUSTOMER" ;; dimen...
Creating a waterfall chart of only measures?
Hi, I am trying to create a waterfall chart but have been getting stumped unfortunately. According to this pag...
Extend view with conditions
Hi All I would like to know if I can create an extended view, with conditions in the extend on what it should ...
Column headings based on pivot row
I’m trying to write some LookML to have column headings in a visualisation show the value of the pivoted row a...
