0 Replies Latest reply: May 15, 2017 10:28 AM by Nicoals Martin RSS

    Create histogram based on several columns values

    Nicoals Martin

      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)

       

      PersonsQuestion 1Question 2Question 3
      John341
      Jenny431
      Max312
      Igor121

       

      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