90 Days Rolling

[sat_tok52]

Hi Guru's

I want show 90 days rolling on bar chart,i have a date column and i written expression like below.

count({<Date={'>=$(=Date-90)<=$(=Date(Today()))'}>} Id) 

Any help thanks in advance.

Thnaks,

Sateesh

[tamilarasu]

Hi,

Try,

count({<Date={">=$(=Date(Today()-90))<=$(=Date(Today()))"}>} Id)

Make sure your date field format should match with expression. Else you need adapt like

count({<Date={">=$(=Date(Today()-90,'DD/MM/YYYY'))<=$(=Date(Today(),'DD/MM/YYYY'))"}>} Id)

Change the highlighted format to your Date field format.

Let me know.

[jagan · Accepted solution]

Hi,

I think date format is the issue

Count({<Date={'>=$(=Date(Date-90))<=$(=Date(Today()))'}>} Id)

Check this link

Set Analysis for certain Point in Time

[harithadogiparthi505]

Hello, 

I have encouraged an error when placed in a pivot table one week is showing data and when  2 weeks get selected second week data is missing. Any help?