4 Replies Latest reply: Nov 22, 2011 11:12 AM by malte windlle RSS

    Count number of unique values and present it in a diagram

      Hi

       

      I need help to present the number of times each unique word in a collumn apperas. Like COUNTIF in excel.

       

      COLLUMNDATA

      Red

      Red

      Green

      Red

      Yellow

      Yellow

       

      RED=3 GREEN=1 YELLOW=2

       

      I also want this presented in a diagram with one bar divided in sections for each value.

       

      Thankful for any assistance.

      Best Regards

      Malte (Sweden)