Need Some Inspiration On How to Represent This Data

Edgar_Movius · July 2024

Hi folks

I need some inspiration on a chart type to represent the following data:

User	Feature A	Feature B	Feature C	Feature D	Feature E
User 1	Yes	Yes	No	No	Yes
User 2	No	Yes	No	Yes	Yes
User 3	Yes	No	No	Yes	Yes
User 4	Yes	Yes	No	No	Yes
User 5	No	No	Yes	No	Yes
User 6	No	No	Yes	No	No
User 7	Yes	No	Yes	Yes	No
User 8	Yes	Yes	Yes	Yes	No
User 9	Yes	Yes	No	No	Yes
User 10	No	Yes	No	No	Yes

The above table is just an example of the data, where we have thousands of users with one or many features enabled.

What I am struggling with is to find a way to represent the grouping of users with one or many of the same features enabled. For example:

User 1, 4, 8, 9 are the in the same grouping because they have Feature A and B enabled
User 1, 4, 9 are in the same grouping because they have Feature A, B and E enabled

Any recommendations would be appreciated.

ArborRose · July 2024

A heatmap can be an effective way to show which features are enabled for which users. Each cell in the heatmap can represent whether a feature is enabled (e.g., Yes/No or 1/0).

Pivot the data so that each row represents a user-feature combination.

User,Feature,Enabled
User 1,Feature A,Yes
User 1,Feature B,Yes
User 1,Feature C,No

Set the X-axis to Features.
Set the Y-axis to Users.
Set the color based on the Enabled field (Yes/No).

A stacked bar chart can show the total number of features enabled per user, and by color-coding the bars, you can differentiate between different features.

X-axis: Users
Y-axis: Count of enabled features
Color: Different features (Feature A, B, C, etc.)

ArborRose · July 2024