Composing comparison groups based on different categorical columns

Hi everyone,

I have a dataset from a survey, consisting of a unique rows (representing respondents who have answered a series of questions).

The following columns are in the dataset:

• Respondent ID (unique)
• Business Unit (categorical)
• Level (categorical)
• Gender (categorical)
• Columns for each question with an answer from 1 to 9

I transposed the data to be able to calculate avg, stdev etc for each of the questions, and make visuals for each of the categories.

So far so good.

But now I want to take it one step further:

I want to build a comparison visual, where I would like users of the dashboard to be able to choose which "groups" they want to compare, but from different categories (BU, Gender, Level).

E.g., compare the average scores for all questions between Business Unit = X (=group 1), and Gender = Male (=group 2).

It would be even better if people could "compose" their comparison groups from all of the categories.

E.g., compare the average score for all questions between BU=X-Gender=Male-Level=Manager and BU=X (so in essence compare a subgroup with the BU total), or any of the combinations.

Any insights on how to do this would be much appreciated !

Thanks in advance 🙂

Dieter from Brussels