Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
@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)
@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)