3 Replies Latest reply: Jan 19, 2017 4:54 PM by David Coggeshall RSS

    Counting Duplicate data in a field

    David Coggeshall

      I have created a field called Repeat Customer. This field Concatenates the Customer Name, Category, Sub-Category, and Type. I am trying to find the number of times each individual Repeat Customer comes back. I've tried doing this with a Sum/Aggr combo, but it is still giving me all of the values, even when there is only one instance of that value in the dataset. Here is an example. So I would not want to count The Katrina Bennett Value as a repeat, because it was two spate services she was getting. I would want to Count Jeffrey Sarlin as a duplicate because it was the same service.  Her is the function I'm using, would love to get some feedback on it.

       

       

      Sum(Aggr(IF(count([Repeat Customer])>1,1,0),[Repeat Customer]))

       

      2017-01-19_15-52-25.png