Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I am trying to get the last 20 Dates as bar chart dimension.
I am trying this formula.
=aggr(Only({1<ReportDate={">=$(=FirstWorkDate(Max(ReportDate),20))"} >} ReportDate),ReportDate)
Since, I am using "1" as set identifier, I was assuming it should return the last 20 dates irrespective of date filter but, it is still returning it based on date selected only. So, my current selection is 1 Jun to 15 Jun, so it is returning dates from 1 Jun to 15 Jun only. and the result is same when I change the set identifier to "$".
May be try this
=Aggr(
Only({1<ReportDate={">=$(=FirstWorkDate(Max({1} ReportDate), 20))"}>} ReportDate)
, ReportDate)
Thanks Sunny,
I tried this but still no luck. It still shows the same date range
Are you using this as an expression or dimension?
Dimension
I am trying to get the last 20 Dates as bar chart dimension
Ok. I have found out the problem. So, seems like my initial formula was correct but I needed to add {1} in measures to get those measure values irrespective of selection. After I have added the {1}, the formula is working as intended
Thanks Sunny and sorry for wasting your time