Hello,
I would like to create a histogram counting values in separated columns for a customer survey and be able to filter them: (1- > Low score / 4-> high score)
| Persons | Question 1 | Question 2 | Question 3 |
|---|
| John | 3 | 4 | 1 |
| Jenny | 4 | 3 | 1 |
| Max | 3 | 1 | 2 |
| Igor | 1 | 2 | 1 |
Each bar would be connected to a column.
bar 1 = sum(Question 1) = 11
bar 2 = sum(Question 2) = 10
bar 3 = sum(Question 3) = 5
It is possible to do it with the valuelist function but we cannot filter the values.
How can we have an histogram per column and be able to filter them directly?
Many thanks in advance,
Nicolas
