topic Re: Display User with most orders in specific step in App Development

Display User with most orders in specific step

Alarkis — Sat, 16 Nov 2024 04:46:31 GMT

Hello,

What to Display User with most orders in this step

Count({<DateType = {'Action_Date'}, Year ={$(vMaxYear)} ,STEPNAME={'Approval'},TASK_ID ={'ApprovalTask'}>}distinct Order_NO)

How i can use Aggr() or Rank() to display only the name of user with most orders in this step

(Assuming user field is USER_ID)

Re: Display User with most orders in specific step

Yoshidaqlik — Thu, 05 Sep 2019 10:26:40 GMT

can do it that way

Aggr( if( Rank(Count({<DateType = {'Action_Date'}, Year ={$(vMaxYear)} ,STEPNAME={'Approval'},TASK_ID ={'ApprovalTask'}>}distinct Order_NO),4)=1 ,USER_ID ) ,USER_ID)

Regards

Re: Display User with most orders in specific step

Alarkis — Sun, 08 Sep 2019 04:41:01 GMT

Hey Yoshidaqlik

thank you for your help

can you explain to me about the

4)=1

part

Re: Display User with most orders in specific step

Yoshidaqlik — Mon, 09 Sep 2019 10:38:00 GMT

4)=1

, 4) serves to inform the Rank function that does not repeat the placement, that a number is always incremented for subsequent positions

= 1

is to inform the if function to only bring the values when the rank function is 1

Regards