count by distinct customer and summed value by date
My brain isnt working today
I have a transaction table with customer id transaction date and transaction value. Customers may make multiple transaction per day.
I have a pivot table with transaction date as dimension and sum(value) and count(distinct customer id) as expressions
That all works fine, but what I need is another column with count of distinct customer id of customers spending more than £50 per day. Everything I try bring back junk.
e.g.
Date Total Order Value Total Customers Total Customers > £50
