4 Replies Latest reply: Sep 30, 2013 4:14 PM by Abey Chandy RSS

    Count Distinct X Over Time

      I've got a expression I'm struggling with...so pose to the QV experts.

       

      The Bars on the combo below is a simple expression and works fine.

      =Count(Distinct Customer)

       

      But want the line to show the unique customer count by week.  But QV is incorrectly summing it up to 117 (Image002), where it should be 37 (Image003).  I've played around with the Aggr() funciton, but unable to crack it.

      Help

      Jay