Count number of buyer with 1st record within date selection

[elaineng]

I have two simple tables as below, buyer and buyer activity. 1 buyer has multiple records in buyer activity which records number of times buyer interact with us.

Each of the activity, we recorded type of channel customer interact with us and source information.

We need to analyze the information. Within the date selection in buyer activity, we need to count number of buyer with the most earlier (first record - sorted by buyer activity date) Source and Type for each of the buyer. 

Just a pivot table will do.

[vikasmahajan]

Not Sure but try this :

FirstSortedValue(buyer, -Aggr(count(buyer activity), Date))

or

Count( Aggr(FirstSortedValue(buyer activity, -date),buyer))

or

max(aggr(count(FirstSortedValue(buyer activity, -date)), buyer))

Vikas

[elaineng · Accepted solution]

Hi @vikasmahajan , 

I have managed to work it out myself. Thanks.

Dimension:  Aggr(FirstSortedValue(Source ,date), buyerid)

Exp: count(buyerid)

[vikasmahajan]

if you found thread useful mark it with correct answer

Thanks