Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
elaineng
Contributor III
Contributor III

Count buyer no of 1st channel & source within date range

I have two tables:
1) Buyer (buyerid, name, age,...)

2) Buyer activity (buyer activityid, buyerid, date, channel, source, etc)

I need to create a table which count the buyer no for 1st channel and source within the buyer activity date range selected by user.

Labels (2)
1 Reply
elaineng
Contributor III
Contributor III
Author

I tried:
dimension: channel 
Exp: = count(IF(BuyerActivity_createdon = Aggr(Min(BuyerActivity_createdon), buyerid), buyerid))

It will give me the result I want

elaineng_4-1673516586285.png

 

elaineng_1-1673516386989.png


But if I selected date, it is not providing the correct result. Eg: 02/01/2023 7:12:33 PM onwards

elaineng_5-1673516636735.png

 

elaineng_3-1673516475273.png


Landing page should count as 1 as it is the earliest record.