topic Getting the previous months sum of data but ignoring the filter that has been selected in App Development

Getting the previous months sum of data but ignoring the filter that has been selected

Rogers2212 — Sat, 16 Nov 2024 17:58:05 GMT

Hi, I have a dashboard and it can be filtered by month. I get a sum in a KPI box and next to the box i want to show what the previous months volume is.

I have used the below and modified it from another post however it only returns the same months volume. Any Ideas as to what i am doing wrong?

Sum({<call_date = {">=$(=MonthStart(AddMonths(Max(call_date), -1)))<=$(=MonthEnd(AddMonths(Max(call_date), -1)))"}>} totalcalls)

Re: Getting the previous months sum of data but ignoring the filter that has been selected

sunny_talwar — Thu, 15 Oct 2020 13:28:15 GMT

@Rogers2212 May be this... make sure to ignore selection in MonthField because that will conflict with your set analysis unless you tell you expression to ignore selection in MonthField

Sum({<call_date = {">=$(=MonthStart(Max(call_date), -1))<=$(=Date(Floor(MonthEnd(Max(call_date), -1))))"}, MonthField>} totalcalls)