I have a chart that calculates a value using aggr and avg functions. I need to compare this value to a set of another values in a table and show a rank value.
Value calculated is say 89.19
and so on. So my value should compare this table and since it falls between Rank 15 and 16 it should take the minimum rank out of it.
I need to use this expression in a line chart. Can someone help me.
Thanks in Advance.
I somehow populated the chart using set analysis but the issue now is that the values are not changing based on dimension.
now how i can make the value respond based on the dimension.
Dimension :dategroup (cyclic group with month,quarter and year)
Thanks in advance
Your expression looks completely out of order, I wonder how it is even working. Besides, it will be very difficult to say what you would need without having a look at what you have got. Would you be able to share a sample?