I have a DSO with data like this:
-
Transaction No / Customer
-
1 / 1
2 / 1
3 / 1
4 / 2
5 / 2
6 / 3
-
(i.e. a list of transactions with a customer ID assigned)
I want to create a query that looks like this:
-
Group / Customer Count
-
Two or less transactions / 2
Three or more transactions / 1
-
(i.e. two buckets, one count of how many customers have 2 or less transactions, one count of how many have three or more transactions)
Can someone give me an idea of how this could be performed? Can I do it with just one query, or do I need to load the data from the DSO into a new DSO with data agregated for customers somehow?
Any suggestions would be greatly appreciated.