Create histogram based on several columns values

Mon, 15 May 2017 14:28:51 GMT

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

topic Create histogram based on several columns values in App Development

Create histogram based on several columns values