Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Senor_Dai
Partner - Creator II
Partner - Creator II

Aggregation & Set Analysis within Variable

Hi,

I have two Dimensions :

  1. User
  2. Department
  3. AuditTime

and two Flag fields:

  1. Flag_Today
  2. Flag_Checkout

I have the following variable: 

=Count({<Flag_Checkout={'1'},  Flag_Today={'1'}>}AuditTime) 

Can anyone advise on creating a second variable that shows the highest Count by User .  Eg, vHighestCheckout could show 50 for 'today' 

If I use the following Example Pivot :

Screenshot 2021-11-04 at 14.21.04.png

Id like a variable that contains '11' 

Many thanks for any help

Dai

Labels (1)
  • Other

1 Reply
MayilVahanan

Hi

Try like below

=Max(Aggr(Count({<Flag_Checkout={'1'},  Flag_Today={'1'}>}AuditTime) , User))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.