topic Re: Ranking KPI in App Development

Ranking KPI

GeorgeEard — Mon, 17 Mar 2025 11:19:15 GMT

Hi,

Does anyone know why every partner (FW Account Name (report name)-Partner) I select is giving the rank of 1 in my KPI?

I'm using the formula : =aggr(rank({<[FW Account Name (report name)-Partner]>}(Scores)),[FW Account Name (report name)-Partner])

where 'scores' is a master measure and Partners are being ranked so that when selected the partner with the highest score will be 1 on the KPI and the lowest will show 51

I am thinking it currently is because when i select a partner all other scores are filtered out, any idea how to stop that?

Scores:

Re: Ranking KPI

Chanty4u — Mon, 17 Mar 2025 15:09:02 GMT

Try this

=Aggr(

Rank( {< [FW Account Name (report name)-Partner] = >} Scores ),

[FW Account Name (report name)-Partner]

)

Re: Ranking KPI

GeorgeEard — Mon, 17 Mar 2025 15:24:40 GMT

Hi thank you for your reply,

However unfortunately it is still returning every partner as 1.