Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am getting an error when representing 90 day rolling average in pivot table.
avg(aggr(avg({<date={">=$(=date(max(date)-90,'MM/DD/YYYY')) <=$(=date(max(date),'MM/DD/YYYY'))"}>}COUNT),[File Number],[Day]))
when selecting one week dates in date range picker, the values were good enough.
when selecting 2 weeks in date range picker the first week values are good and second week values are showing null in pivot table.
Kindly help me in resolving this issue when calculating 90 days rolling average.
Any help greatly appreciated.