Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having trouble getting the Sum for the last five months in a line chart.
Here is the expression I'm using that is not giving me exactly what I need.
=only({1<DateDT = {"$(= '>=' & addmonths(Max(EventDTS), -5))"}, Campus = {"Combined"}>} SSENBR)
I need to add in a Sum(SSENBR) somewhere and I don't know how to do that with 'only'
Any suggestions?
replace Only with Sum?
When I do that it starts to pull in more than the last five months, which is why I need 'only' or something similar
So when you use this
=Sum({1<DateDT = {"$(= '>=' & addmonths(Max(EventDTS), -5))"}, Campus = {"Combined"}>} SSENBR)
you see data from more than 5 months old... but when you use this
=only({1<DateDT = {"$(= '>=' & addmonths(Max(EventDTS), -5))"}, Campus = {"Combined"}>} SSENBR)
You see only 5 months of data? Really? Would you be able to share an image with both expressions and may be DateDT as your dimension to show this?