Change the drilldown hierarchy level of multiple charts at the same time

[Andrew17]

Hi everyone,

I have a bunch of charts on one page, and they are measuring a bunch of metrics over time. My data is set up so I have a hierarchy of Date/Week/Month/Quarter/Year for each of those fields. I want to be able to have a filter I can click where I can change the x-axis from one of the levels of the hierarchy and have it change on all of the charts. Is this possible?

Thanks!

[TomMartens · Accepted solution]

Hey @Andrew17 ,

this is not that easy as one might hope. I guess this video provides a solution, how you can achieve what you are looking for: https://www.youtube.com/watch?v=n-OWNaCUU0o

Regards,

Tom

[TomMartens · Accepted solution]

Hey @Andrew17 ,

this is not that easy as one might hope. I guess this video provides a solution, how you can achieve what you are looking for: https://www.youtube.com/watch?v=n-OWNaCUU0o

Regards,

Tom

[Andrew17]

I was able to do this using the info from the video you posted. Thanks so much!! It actually wasn't too hard.

[VelsyVels]

Hey

Can you please share how you did it?
The example in the video is not about changing the hierachy level in charts, so I am confused how you applied the video example to your challenge about applying same granularity in a hierachy in multiple charts....

[TomMartens · Accepted solution]

Perfect!