13.11. Dynamic Date Range Granularity Selector - Looker Studio Tutorial/Data Studio Training Course
The dynamic date range granularity selector allows you to change the granularity of a chart in Looker Studio without navigating to different pages or using multiple charts. This can be achieved using parameters, case functions, and controls in a creative way.
Looker Studio Certification:
When you're ready, take the final exam to test your knowledge and become a certified Looker Studio Expert →
https://lookerstudiomasterclass.com/l...
📩 http://lookerstudio.tips → Receive my weekly Looker Studio tips.
💬 http://lookerstudio.community → Get help with Looker Studio.
🔔 Subscribe and turn on notifications so you don't miss the future lessons!
Setting Up the Dimension
First, create a dimension using a case statement. The dimension should change based on the value of a parameter. For example, when the parameter's value is 1, the dimension should display dates in a day format, and when the parameter's value is 2, the dimension should display dates in a week format, and so on.
Creating the Parameter
Create a parameter of type number with a range from 1 to 4 (or any other range based on your needs). This parameter will be used to determine the granularity of the chart.
Creating the Click Effect
To create the click effect, follow these steps:
1. Add icons for each granularity level to your report (e.g., daily, weekly, monthly, and yearly).
2. Place a slider control in your report, setting the opacity to 0, making it completely transparent.
3. Adjust the slider control's position so that it overlays the icons, creating the appearance of clickable buttons.
When users click on the icons, they will actually be interacting with the transparent slider control. The slider control will change the value of the parameter, and the chart's granularity will update accordingly.
Example
In the given example, a chart's granularity can be changed from daily to weekly, monthly, and yearly views without changing the URL or navigating to a different page. This is done by creatively using case statements, parameters, and controls in Looker Studio.
Remember that this technique is a clever workaround and may not be officially supported by Looker Studio. Nonetheless, it can be a useful way to create a dynamic and interactive report.
*Note:* The mentioned technique was developed by Mehdi Oudjida at https://how.withlookerstudio.com/
En esta página del sitio puede ver el video en línea 13.11. Dynamic Date Range Granularity Selector - Looker Studio Tutorial/Data Studio Training Course de Duración hora minuto segunda en buena calidad , que subió el usuario Siavash Kanani (Ahmad) 08 mayo 2023, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 7,185 veces y le gustó 78 a los espectadores. Disfruta viendo!
