Hey all,
I’ve searched everywhere and couldn’t find an answer
i would like to emulate a window functions in one of my looks

as you see i have 2 dimensions: created_at and merchant_id
and one measure: URLs which is a STRING_AGG function
im trying to add a second measure that counts per each created_at_time the number of merchant_id’s per this timestamp
so if it was plain SQL id write: count(distinct merchant_id) over(partition by created_at)
i’ve seen 3 posts where
Thanks!
Best answer by chris.seymour
View original