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
View original
+10
Hey
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.
Amazing sir, you are a genius
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.