1

I have a dataset of customers and products they could have. There are a total of 5 different products (A,B,C,D,E). A customer can have any combination of the products, for example a customer can have just A or AB or ABC. So there are 31 total combinations that a customer can have.

Is there a graphic anyone can recommend to display all possible combinations and a count for each one? For example A - 20, AC - 50, etc.

The only option I could think of was a 31 x 31 matrix and use color to signify values. It will be a big table but at least it will show a high level view of the data.

1

Do you need to just display the combination and number?

Have you tried a concentric ring graph (each ring being a product)? Example here: https://www.theguardian.com/world/interactive/2012/may/08/gay-rights-united-states Color in the spaces that represent owning a product and place the number on the outside of the ring (where the state is in the example).

Or perhaps overlapping circle graph / venn diagram (each circle being a product)?

  • 1
    this is a very interesting chart, had to draw it up on the whiteboard to understand how it will works. I don't think it will apply very well in this situation because the thing which draws the eyes on the graph is the color. In my situation, the color would be simply a product combination and the most important part, which is the count, would just be a number. I think I will be able to use it in my analysis, just not for this part. – jmich738 Mar 6 '18 at 4:44
1

While it's nice to have an option to see a full matrix of possible combinations, as an addition to it, a matrix with a collapsible rows can be shown as well.

A high-level approximation presented below.

  1. The initial state:

mockup

download bmml source – Wireframes created with Balsamiq Mockups

  1. When a user presses the + button next to a row:

mockup

download bmml source

  1. It expands, showing the combinations amount, that themselves can be expanded:

mockup

download bmml source

Please note, that it is a general idea that should be evolved further for the needs of an effective representation considering what kind of analysis will be performed on the data.

  • 1
    I agree with your comments. I guess I was looking for something like a correlation plot or a heatmap. But maybe it does not fit this type of dataset. A drilldown table will be a good option, but probaly too much work for the type of insights we are looking to get out of this dataset. I will probably just stick with a simple table. Out of all the 32 combinations, it's very likely that only 3 or 4 would actually be of interest. – jmich738 Mar 8 '18 at 23:05

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.