frequency report / temp table?
Hello - I cant figure out how to create something like frequency report based upon transaction data. As an example, imagine if you wanted to know a "frequency" of purchases by day per customer. the goal would to get an output like this. 3 Customers have made 1 visit to the store, 2 have made 2 visits etc..
Here is the final goal (frequncy of visits)
The raw data would be something like standard retail or eCommerce data simplified like this:
I can't figure out how to make a frequency report like this. I can create the first step which would probably be a Count of Visits by ID which may look like this. However then you would need to use this result set to then re-transform the data.
Any ideas would be really helpful!
Here is the intermediary table via excel: