9 Replies Latest reply: Jan 17, 2013 3:58 AM by Stefan Wühl 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?