How to create a sales by days range visualization

[biuser]

Hi,

I am trying to create a graph with sales in Y-axis vs Days range in x axis

I will have days range for example- 1-25, 25-50,50-75,>75 on X-axis and Y axis would be sales.

How do I calculate a day range if I have to using todays date and a start date. I want to put those day range in buckets and visualize my data.

[Peter]

Hi biuser,

Can you let me know if this solves your issue?

ifelse(
dateDiff(now(),{date_field})<=25,‘1-25’
,dateDiff(now(),{date_field})<=50,‘25-50’
,dateDiff(now(),{date_field})<=75,‘50-75’,
‘75+’)

Thanks!

[biuser]

Thank you so much @Peter . Appreciate your help on this!