Dimension Control

Looker Q&A Looker Studio
,
1

I want to create several visualizations on my dashboard using Google Looker Studio, including a line chart, bar chart, and table. For the line chart, I need to control its dimension based on whether it shows data by month or week.

The monthly data has two periods: 9 and 10. The weekly data varies:

  • Month 9 has 4 weeks
  • Month 10 has 2 weeks

I want the line chart to display data by month if multiple months are selected in the dropdown list, while showing data by week if only one month is chosen. How can I achieve this dimension control specifically for the line chart without affecting the other visualizations (bar chart and table)?

Is there a way to implement this functionality within Google Looker Studio?

2

@calculose

Turning on the drill down (setup tab) and displaying the chart header (bottom of style tab) of your series chart would be the easier way to get a manual switch between time granularities.

Mehdi_Oudjida_0-1729233822082.png
Mehdi_Oudjida_0-1729233822082.png573×350 22.2 KB

If you need something adaptative, you have to combine some tricks described in this article (especially at the end of the automatic adaptation of the granularity)

https://how.withlookerstudio.com/advanced-controls/20210317-time-granularity-slider-for-looker-studio-date-series-charts/

I hope it helps.

Feel free to tell me if you need more info, otherwise you can accept this answer as a solution.

Mehdi

1 Like
3

Thank you, sir. I will try it