Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an expression written in variable overview. I want to use this variable in 'calculated dimension' inside a chart.
For example, variable that I created: vSumOfAll = sum(x)+sum(y)
and I am using vSumOfall inside calculated dimension as :
rank(aggr($(vSumOfAll),[STATE]),4)
This shows an error. Any help on this is highly appreciated.
Regards.
Hi
In order to use a calculated dimension you need to wrap-up the expression with an aggr function, try moving the position of the ranking function:
aggr(rank($(vSumOfAll),4),[STATE])
Hi
In order to use a calculated dimension you need to wrap-up the expression with an aggr function, try moving the position of the ranking function:
aggr(rank($(vSumOfAll),4),[STATE])
Hi,
If you do that :
aggr(rank($(vSumOfAll), 4), [STATE])
Aurélien
Thank you. It worked though it is difficult for me to understand why it worked this way. I thought rank was decided post aggregation and hence wrote the expression in that fashion. Thanks again..