Need Some Inspiration On How to Represent This Data

Edgar_Movius
Edgar_Movius Contributor

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:

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

Any recommendations would be appreciated.

Tagged:

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    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.)

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    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.)

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **