Cumulative average in gauge chart

[#1]

Hi,

I have month wise values and I want to represent the average of cumulative of those values in a gauge chart.

The formula I have used is:

NUM(AVG(AGGR(rangesum(count(distinct V1),above(count(distinct V1),1,RowNo()))

/

rangesum(count(distinct V2),above(count(distinct V2),1,RowNo())),Month))*100,'###.##')

But since it is a gauge chart, I don't think above() function will work here.

Can someone please suggest me what formula should I use.

Thanks in advance

Parul

[sunny_talwar]

Well since you are using Aggr function, this might still work. But just by looking at the expression it would be difficult to give any suggestions. Would you be able to share a sample with us Parul?