4 Replies Latest reply: May 25, 2018 1:40 AM by Isabel Encinas RSS

    count of count greater than a number

    Isabel Encinas

      I have 3 columns:

       

         

      SD.Customer Formatted Numberoriginal dimension (caller number)
      Customer Contact IDbasically an expression to correct the format=IF(Index([SD.Customer Formatted Number],'tel:')>=1, KeepChar([SD.Customer Formatted Number], '+0123456789'), IF(index([SD.Customer Formatted Number], 'sip:')=0, [SD.Customer Formatted Number], mid([SD.Customer Formatted Number], 5)))
      Count([SD.Customer Formatted Number])count of calls

      Count([SD.Customer Formatted Number])

       

      fcr sample.JPG

       

      Now, I want to count the number of callers that called more than once (email add not included)

       

      Desired Result:

        

      DateRepeat callers
      5/8/20182
      5/9/20183