How can i Adjust the range of an X-axis of my chart view?

[marvaddi]

I have this chart and I would like it to show only the past three bars(or weeks) but it's showing data from 2021 and also future dates which is unnecessary, how can I achieve that?

[Suvrutt_Gurjar · Accepted solution]

Please create a slice on the view with a filter expression something like 

AND([Date]>=TODAY()-21 ,  [Date]<=TODAY()) 

Then create the map view based on that slice.

[marvaddi]

Hey, the formula worked fine I'm just confused why you said to create a map view. I tried it and it just gave me a map of the world lol. I'm I misunderstanding you?

[SkrOYC]

Yes, probably he meant chart view

[Suvrutt_Gurjar]

@marvaddi :Sorry, it was a typo. I meant chart view.🙂