Forum Discussion
Frequency Count
If I read your expected outcome then you don't want to show how many "Active" Plans each customer has. What you are asking for is a bucketing of how many customers a group of plans has, sort of a double histogram. Can you please clarify?
Anyway, here's the first step. Number of active plans per customer.
Next step is to create a measure table to do the grouping, and hopefully also be able to list the customer IDs as a bonus
Question: It would be much simpler if one could start with a static list of
0
1
2
3
4
...
active plans. Would that be acceptable?
2.1 is not about the number of plans, it is about the unique number of plans a group of customers may have. As I said, a double histogram (bucket in a bucket). Even if you have a million customers the number of plans each of them has must be much smaller, no?
Ahhh!! That makes sense.
I will try.
Thank you very much.