Count group by

[flygstolen_fred]

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

[Gysbert_Wassenaar · Accepted solution]

Try as dimension =aggr(count(distinct OrderID),CustomerEmail) and as measure =count(distinct CustomerEmail)

[flygstolen_fred]

Thanks, worked like a charm!