Looker Dashboard - Filters: Switch between monthly, weekly, daily views

Niki1
New Member

Hello Community,

I am creating a looker dashboard, based on the -let’s say- last 5 days with a barchart of certain metrics per day, and would like to add a filter on the top of the dashboard to show me they last 5 weeks (or last 5 month etc.)
Is that possible to switch easily between days, month etc.?

Basically I would like to switch between daily charts to aggregated weekly and monthly views with only a click for the Enduser.

Thanks in advance for any reply!

Solved Solved
4 4 7,959
1 ACCEPTED SOLUTION

I believe what you’re asking for is Dynamic Granularity. Here is a doc from Looker’s help section to show you how it can be done:

https://help.looker.com/hc/en-us/articles/360001288468-Dynamic-Timeframes-for-Dimension-Groups

0bcfc6fb-b6d3-427b-a2de-d4898acc701d.png

View solution in original post

4 REPLIES 4
Top Labels in this Space