This content has been marked as final. Show 3 replies
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]))