Aggregation & Set Analysis within Variable

Senor_Dai — Thu, 04 Nov 2021 14:23:02 GMT

Hi,

I have two Dimensions :

and two Flag fields:

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 :

Id like a variable that contains '11'

Many thanks for any help

Dai

Re: Aggregation & Set Analysis within Variable

MayilVahanan — Fri, 05 Nov 2021 09:54:15 GMT

Try like below

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