4 Replies Latest reply: Jun 16, 2016 4:34 AM by Rubandoss H RSS

    Unique count for Statistics Box

    David Kwiatkowski

      How can I get a unique count? I tried the Statistics box but this gave me a total count. I have a customer ID and their spend. Looking at the chart below, I just want to see how many unique customers I have. For example, below would be 3 unique customers (1234, 5678. 7890). I don't need their spend, just a count of how many customers.

       

       

       

      IDSpend
      1234$10
      1234$10
      1234$10
      5678$10
      7890$10