2 Replies Latest reply on May 9, 2013 9:43 AM by Edgar W.

    grouping values plus group count

    Edgar W.

      Hello community,

       

      I am a tableau newbie trying to solve the following challenge:

       

      I have a bunch of products and their price.

      Each product has one price.
      Prices range from 1$ to 50$.

       

      I want to group prices into 5 groups of "between 1$ and 10$", "between 11$ and 20$", ...

      Plus: I want to have a count of prices per group, i.e. "there are 42 products in the 31$-to-40$ group".
      That information should be presented in one pie chart: sectors being the price-groups, each sector having the count as an annotation.

       

      I had a go at it with sets. But did not succeed :-(

       

      cheeers + thanks for your support,

      Edgar