Dashboard - Build a parameter that show value from a view or from another

[jhgaf]

Hi,

I’m looking to build a dashboard showing the turnover of our firm. Usually people in our firm will query turnover from a given month or from a given day. 

In order to optimize performance we created a table in big query that is partitioned by days. But when we show month it still takes some time to show the figures.

So we wanted to created another table that is basically the same query but pre-aggregating by month. And then we partition by month.

How can I build a parameter that allows me in a dashboard : 

1/ when i’m choosing day granularity, look for the view partitioned by day

2/ when i’m choosing month granularity, look for the view partitioned by month

[olga1]

Hiya! 

Actually you can use native Looker functionality of aggregate awareness and Looker will decide itself which aggregate table to use depending on the granularity needed - it will look for the smallest, most efficient table available.

You will just need to add an aggregate table to the explore using this syntax https://docs.looker.com/reference/explore-params/aggregate_table. You won’t need to use parameter/liquid to tell which table to look into.

You can read more about the concept and how it works in Looker in detail here: https://docs.looker.com/data-modeling/learning-lookml/aggregate_awareness

That’s a pretty cool functionality, I hope you’ll like it ?

Best,

Olga