Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Correl(Aggr(Sum({<Color = {'Orange'},[YFlag] = {1}>} Value),MeasureDate),Aggr(Sum({<Color = {'Blue'},[YFlag] = {1}>} Value),MeasureDate))
So the above expression works perfectly
I now want to open it up for my users to pick "Colors" to compare
I know the Variables are throwing the correct values, because every other object that depends on them is working.
The expression checker says syntax for the following is ok:
=Correl(Aggr(Sum({<Color = {$(vColor2)},[YFlag] = {1}>} Value),MeasureDate),Aggr(Sum({<Color = {$(vColor1)},[YFlag] = {1}>} Value),MeasureDate))
But I get a Null Value.
I am thinking I might have to change this back to a Sum if, but having to include two dimensions it made more sense to use set analysis.
Let me know if you have any suggestions.
Thanks again.
So I figured this out.
=Correl(Aggr(Sum({<Color = {"$(vColor2)"},[YFlag] = {1}>} Value),MeasureDate),Aggr(Sum({<Color = {"$(vColor1)"},[YFlag] = {1}>} Value),MeasureDate))
I really did try putting quotes in earlier, but they didn't work. I think I may have been putting them on the wrong side of the $.
So I figured this out.
=Correl(Aggr(Sum({<Color = {"$(vColor2)"},[YFlag] = {1}>} Value),MeasureDate),Aggr(Sum({<Color = {"$(vColor1)"},[YFlag] = {1}>} Value),MeasureDate))
I really did try putting quotes in earlier, but they didn't work. I think I may have been putting them on the wrong side of the $.