11 Replies Latest reply: Sep 9, 2018 2:09 AM by Mahi Chowdary RSS

    How to group data in a column to create count graph

      Hello,

       

      I would like to be able to group data in a column to create a graph.

       

      The column in the table look like this:

       

      DataTypes
      red
      red
      blue
      blue
      green
      green
      short
      short
      long
      long

       

       

      So I would like to create one group for colors (Colors) and one group for length (Length), Then I want to count the total value of data in each of the groups, and make a percent pie-chart with the two groups.

       

      How can I do this?