4 Replies Latest reply: Apr 29, 2014 10:28 AM by Herbert Chitate RSS

    Count Distinct per Dimension

      Hi All,

       

      I have a straight table which has dimensions week day and date. I have an expression "Count(DISTINCT([Grower No.]))", which counts the distinct number of growers in the least.

       

      How do I tweak this expression so that it shows distinct number of growers per date? At the moment it has the same value for each date which is the distinct number of growers in the whole subset.

       

      Thank you

       

       

      Herbiec