How do I make a dynamic datetime axis on a graph?

Question & Answer
, , , , ,
1

Hi all,
How can you make a datetime x-axis dynamic? I have a calculated field displayed that only looks at the last 12 months from the current time, so it’s a moving calculation. I want the datetime axis to reflect this moving timeline so it doesn’t have a long, trailing 0 flat line behind.

Thank you in advance!

2

Hi @zijingxu ,

You can use a relative filter to limit the data in your visual to the last 12 months. This will make the zero lines disappear and make your x-axis dynamic.

Best regards,
Nico

If this helped you, please mark my answer as solution. That helps the community to find solutions faster.

3

Thank you Nico! One additional piece of context I forgot to mention was that I have a sheet-wide control for the date. I’m assuming that the control doesn’t work if I apply the individual filter just for the visualization (and vice versa)? Thank you for explaining.

4

Hi @zijingxu

Thank you for the additional context.

The sheet-wide control filter for the date and from the selected date you want to see the last 12 month in one visual. Do I get you right?

If yes, you can use a relative filter, showing last 12 month and set the 12 month relative to your parameter date. Your sheet-wide control needs to be a parameter for this.

image
image225×720 21.4 KB

Best regards,
Nico

If this helped you, please mark my answer as solution. That helps the community to find solutions faster.

1 Like
5

Hi @zijingxu,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post or was the solution provided above helpful for your case?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

6

Hi @zijingxu,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you