String Associated with Min() of a Different Field

[acbishop2]

Hello All,

The concept seems simple, but I can't seem to get it to work.

I have a calculated field for speed (hours and minutes), and a string field with employee names. I need to have a KPI box that returns the string name of the specialist that has the lowest average speed for a particular task. Here's the sample data:

I'll have a KPI box for each Task, displaying the name of the Specialist that has the lowest average speed for each task. For example, in the VOE box, the name "Teresa" should be displayed because her average speed for the task is the lowest.

I appreciate the help in advance.

Aaron

[maxgro · Accepted solution]

maybe

=FirstSortedValue(Specialist, aggr(avg({$ <Task={'VOE'}>} Speed),Specialist,Task))