Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my data we have transactions by customer Id.
I can do a count(Distinct custid) to find out how many unique customers i had over a period.
I can do count(distinct transId) to find out how many transactions i had over a period
What i would like to do now if to find what was the highest transaction count for the selected period by customer.
I don't need the customer itself, just the highest value.
Kind Regards
Max
Seems to do it ....
(Aggr(Count(Distinct [Trans Id]), [MailCount]))Harry,
From your description, it should be aggregated by customer:
max(aggr(count(distinct transid),custid))