Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
I think date format is the issue
Count({<Date={'>=$(=Date(Date-90))<=$(=Date(Today()))'}>} Id)
Check this link
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.
Hi,
I think date format is the issue
Count({<Date={'>=$(=Date(Date-90))<=$(=Date(Today()))'}>} Id)
Check this link
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?