String Associated with Min() of a Different Field

acbishop2 — Tue, 06 Feb 2018 18:58:32 GMT

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

Re: String Associated with Min() of a Different Field

maxgro — Tue, 06 Feb 2018 19:18:09 GMT

maybe

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

topic String Associated with Min() of a Different Field in App Development

String Associated with Min() of a Different Field

Re: String Associated with Min() of a Different Field