This content has been marked as final. Show 2 replies
Good day dear community,
I came across the following task:
Calculate sum(value) but only for those buyers, which have no less that 5 transactions.
Let's say I have a model with these two tables:
Then I visualize it in a bar chart:
I've achieved the desired result with IF: if(count(trans_id)>=5, sum(trans_value))
But wonder is there a more elegant/efficient way to do the same with set analysis?
Would appreciate any help, thanks