Forum Discussion
Group by Transaction Count
Hello,
I have a visualization. How can I group all of the members who have the same amount of transactions.
For example,
I am visualization for the first two that is the distinct count of the partners that the members used.
I would like to show that two members used 10 partners.
8 members used 9 partners
16 member used 8 partners etc
I am using Direct Query. Please let me know if you need more information.
In the visualization, I am using member number and counting how many times they interacted with a particular merchant.
1 Reply
Add another table to your data model that has a list of your potential bucket values. Then create a measure that computes the number of members falling into each bucket. Suppress items with no data.
