2 Replies Latest reply: May 4, 2014 12:27 PM by Herbert Chitate RSS

    Distribution - Calculated Dimension

      Hi All,

       

      I am trying to create a distribution graph that shows the number (distinct) of clients with a certain Average $/Kg, eg number of farmers between 2.0 and 2.5, farmers between 2.5 and 3.0 etc. I have attached a spreadsheet with some dummy data. I am not sure about the scripting for the calculated dimension. Average $/Kg is Value($)/Kgs. Please also note that each client may have more than one transaction.

       

      Any assistance appreciated.

       

      Herbiec