Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kaylaramsey2
Partner - Contributor III
Partner - Contributor III

Only and Sum used together

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?

Labels (1)
3 Replies
m_woolf
Master II
Master II

replace Only with Sum?

kaylaramsey2
Partner - Contributor III
Partner - Contributor III
Author

When I do that it starts to pull in more than the last five months, which is why I need 'only' or something similar

 

sunny_talwar

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?