Display User with most orders in specific step

[Alarkis]

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)

[Yoshidaqlik · Accepted solution]

hi

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 

[Alarkis]

Hey Yoshidaqlik

thank you for your help 

can you explain to me about the 

4)=1

part 

[Yoshidaqlik]

Hi

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