Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I tried:dimension: channel Exp: = count(IF(BuyerActivity_createdon = Aggr(Min(BuyerActivity_createdon), buyerid), buyerid))It will give me the result I want
But if I selected date, it is not providing the correct result. Eg: 02/01/2023 7:12:33 PM onwards
Landing page should count as 1 as it is the earliest record.