About Piotr_Kalachyn_

Piotr_Kalachyn_ · 09-02-2021

Hi all,I have a LookML dashboard with a filter for two looks- dashboard: overview filters: - name: time_spec title: Event Time Range type: date_filter default_value: last 7 daysboth elements of the dashboard listen to the filter: listen: time_spec: v...

Piotr_Kalachyn_ · 09-03-2021

The reason why my previous attempt did not work was different types of COALESCE arguments. Having checked the generated SQL, I changed to fallback expression (2nd argument) as follows: DATE( TIMESTAMP( COALESCE( {% date_start time_spec %} , TIMESTAMP...

Piotr_Kalachyn_ · 09-02-2021

When I try to DATE( TIMESTAMP( COALESCE({% date_start time_spec %}, DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)))),and define a Liquid filter of the same name as the dashboard filter: filter: time_spec{ type: date default_value: "last 30 days" }the resu...

My Stats

Piotr_Kalachyn_'s Bio

Badges Piotr_Kalachyn_ Earned

Recent Activity

How do I set a liquid parameter based on a dashboard filter?

Re: How do I set a liquid parameter based on a dashboard filter?

Re: How do I set a liquid parameter based on a dashboard filter?