Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There is a column name hours which calculate no of hours employee has worked and a column event which tells event name the employee has participated.I have to calculate rank of a person who has maximum hours and who has participated in maximum events(count of event against his name).also if two person has same rank then display both name in KPI. I want this in frontend.
I would recommend doing such complicated calculations in the script if possible.
{<PersonID = {$(=Concat(Aggr(If(Rank(Sum(Hours), 1) = 1, PersonID), PersonID), ','))}>}
Concat(Aggr(If(Rank(Count(Hours), 1) = 1, Person), PersonID), ', ')