Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with a lot of OrderData and I'm trying to find out how many customer who made one order, how many customers who made two orders and so on. I'm trying to group by / aggr on CustomerEmail but I don't get the result I'm looking for. Anyone that can point me in the right direction? Thanks
OrderID | CustomerEmail |
---|---|
100 | mail1@mail.com |
101 | mail2@mail.com |
102 | mail3@mail.com |
103 | mail1@mail.com |
104 | mail1@mail.com |
105 | mail2@mail.com |
Try as dimension =aggr(count(distinct OrderID),CustomerEmail) and as measure =count(distinct CustomerEmail)
Try as dimension =aggr(count(distinct OrderID),CustomerEmail) and as measure =count(distinct CustomerEmail)
Thanks, worked like a charm!