topic KPI ranking in App Development

KPI ranking

GeorgeEard — Thu, 13 Mar 2025 14:03:26 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?

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

where 'scores' is a master measure

Scores:

Re: KPI ranking

MatheusC — Thu, 13 Mar 2025 14:14:27 GMT

@GeorgeEard
Try ignoring the selection:

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

- Regards, Matheus

Re: KPI ranking

GeorgeEard — Thu, 13 Mar 2025 15:21:21 GMT

Thank you for the reply,

Do you mean add '{<YourSelection=>}' to the measure in the KPI?

If so I changed the measure in the KPI to {<YourSelection=>}aggr(rank({<[FW Account Name (report name)-Partner]>}(Scores)),[FW Account Name (report name)-Partner]) and the same issue is still occurring.

Re: KPI ranking

MatheusC — Thu, 13 Mar 2025 16:25:16 GMT

This YourSelection is an example, then you put the filter field example if your filter field is Customer then it stays:

{<Customer=>}