Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)