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?
