Skip to main content
Solved

Exclude last 4 weeks of data from Segmentation Chart


sebhatyidelwo
Novice
Forum|alt.badge.img

I have a chart that looks below where there is a downward trend as shown.

 

This is a custom formula that I have calculated. I would like to exclude the last 4 weeks of data. Is it possible to add a statement to the formula so that the fisual goes from Apr 18 to June 12? 

 

I want to see all the data that is at least 4 weeks old! 

 

 

Best answer by Saish Redkar

Hey @sebhatyidelwo 

You can use the offset clause to do this

 

Else, if you want to visualize data only between 2 dates then you can use the Between clause in the date picker.
 

 

Let me know if I have understood your use case correctly. Hope this helps.

View original
Did this topic help you find an answer to your question?

2 replies

Saish Redkar
Expert
Forum|alt.badge.img+10
  • Expert
  • 1382 replies
  • Answer
  • July 12, 2022

Hey @sebhatyidelwo 

You can use the offset clause to do this

 

Else, if you want to visualize data only between 2 dates then you can use the Between clause in the date picker.
 

 

Let me know if I have understood your use case correctly. Hope this helps.


sebhatyidelwo
Novice
Forum|alt.badge.img

Amazing sir, you are a genius 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings