User with least time for transaction

[Alarkis]

Hello,

What to Display User with least time for transactions

avg({<Year={$(vMaxYear)},DateType={'RECEIVED_DATE'},WF_TASK_NAME_Time = {'ApprovalTask'},WORK_TIME-={'-1'}>}WORK_TIME)

How i can use Aggr() or Rank() to display only the name of user with least time taken for transaction on average

(Assuming user field is USER_ID)

[treysmithdev]

Try this:

=Only({<USER_ID = {"=Rank(avg({<Year={$(vMaxYear)},DateType={'RECEIVED_DATE'},WF_TASK_NAME_Time = {'ApprovalTask'},WORK_TIME-={'-1'}>}WORK_TIME)) = 1"}>}USER_ID)