Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Let's say, I need to find the avg number of distinct buyers per day so it should be, theoretically, something like this:
avg( aggr( count(distinct buyer_id), date(purchase_time) ) )
but this doesn't work because aggr() can't take computed dimension, I.E - date(purchase_timestamp).
What is the best solution for this?
Thanks in advance.
Dear,
can you try to create a field in the script level.
date(purchase_time) as Purchase_Date
then
avg( aggr( count(distinct buyer_id), Purchase_Date) )
hope it will work.
Thanks,
Mukram
Dear,
can you try to create a field in the script level.
date(purchase_time) as Purchase_Date
then
avg( aggr( count(distinct buyer_id), Purchase_Date) )
hope it will work.
Thanks,
Mukram
I was hoping to find a solution that does not involve without having to redefine the model but I guess there is none.
Thanks!