I am convinced that this is hidden in the millions of answers somewhere, but I can't find it....
I can use
stats dc() to get to the number of unique instances of something i.e. unique customers. But I want the count of occurrences of each of the unique instances i.e. the number of orders associated with each of those unique customers.
Should be simple enough, just not for me. Please help.
Thanks.... but, I tried that before and I didn't get what I wanted, I got a count of the unique values. More experimentation suggests that I have been over-complicating this, because a simple stats count by customer appears to give me what I asked for. Or am I missing something?
Nope, you have found the right answer. The fact that the customer numbers are unique to each customer is incidental. You just want the count for each customer, so stats is the right tool for the job.