Trying to create rolling date with calculated field

Q&A
, , ,
1

Hello community members!

I have a questions, I would like to create custom formula for rolling dates.
For example, if user is registered 2 days ago I would like to assign custom name “2 Days ago”
same for the 3 days ago, 4 days ago and 5 days ago.

Then I would like to exclude all the 5 days and have leftover customers there.

Thanks!

2

Hi @gjan
you could use

combined with

ifelse(datediff < 5,datediff,0)

And filter out all 0
BR

3

Hi @gjan

We hope the response from @ErikG helped you to solve the issue .
Am marking questions as solved , please let us know if you still need assistance.

Thanks for posting your questions on the Quick Sight Community Q&A Forum!

4

Yes, it worked thank you very much!

5

Thank you very much… It worked!