topic Re: Avg Rank Aggr Sum for the Average of Ranks in App Development

Avg Rank Aggr Sum for the Average of Ranks

Oskar_vl — Wed, 27 Nov 2019 12:32:51 GMT

Hi,

is it posible to take the average of ranked values.

This doesn't work:

(The light itself works fine, it is the Rank column in the picture)

avg(
Rank(aggr((sum(Value1)/sum(Value2))
,Dim1,Dim1,Dim1),4,2)
)

This I need:

Best regards

sunny_talwar — Wed, 27 Nov 2019 12:56:24 GMT

May be this

Avg(TOTAL <Dim1> Aggr( Rank(Sum(Value1)/Sum(Value2)) , Dim1, Dim2, Dim3))

Oskar_vl — Wed, 27 Nov 2019 13:31:48 GMT

Unfortunately not

without the <Dim1> I get a result but the wrong one.

And when I insert the Rank parameters ",4,2" there is again no result.

sunny_talwar — Wed, 27 Nov 2019 13:36:18 GMT

Would you be able to share a sample where we can see the issue?

Oskar_vl — Thu, 28 Nov 2019 15:32:58 GMT

I am sorry, I can't share the data.

sunny_talwar — Fri, 29 Nov 2019 15:55:33 GMT

no problem