Forum Discussion
Grouping numeric columns to categories
Hi everyone,
I am trying to group several columns (which represent subcategories) to main categories. My data looks like this:
| Commitment | Responsiveness | Appearrance | Pragmatism | Customization | Proactivity | Innovation |
| 2 | 5 | 2 | 3 | 5 | 2 | 1 |
| 3 | 3 | 4 | 3 | 5 | 1 | 3 |
Now I would like to group the first three columns into the category "Personality" and the last four to "Customer focus", in able to create numeric KPIs based on the main category (e.g. the average for Personality as a KPI visual).
Any help is appreciated! :)
radu92,
You would need to add new column to calculate average of mulitiple columns.
Regards,
Lydia Zhang
4 Replies
Could you please post your expected result in table? How do you want to calculate these values of different columns when you group them into categories?
Regards,
Lydia ZhangI would like to have the average of the subcategories as the main category. I solved it now by just adding a new column that calculates the AVG(column1, column2, etc.), but I was wondering if this could be done without an extra column.
radu92,
You would need to add new column to calculate average of mulitiple columns.
Regards,
Lydia Zhang
