Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a question about the label of a KPI that I would like to make dynamic.
I have a team of 20 people (in my database as "player") that make a score every week (in DB: "points of the week"). I would like to create a display of the best score of the week and this score clearly changes every week and consequently also changes the name of the person who records it, which I would like to be displayed on the label.
How can I do this?
Thank you.
As you want to add players' age, you just modify the previously described formula to aggregate that too, so:
=FirstSortedValue(Player, -Aggr(Sum(Score), Player,Age))
Another solution would be to list all players with the best score if you aggregate just the score per player:
=concat(distinct aggr(if(sum(Score) = max(total aggr(sum(Score), Player)), Player), Player), ', ')
Thanks! It works whit the first solution
Thank you @GnaneswarReddy I'll try also with your solution!