2 Replies Latest reply: Jun 25, 2018 7:22 AM by Sunny Talwar RSS

    Count distinct with different formats

    Isabel Encinas

      Hi Everyone,

       

      I want to count the unique customer that have more than 1 # Offered using expression. but some of the CSD. Formatted Number has different format.

      (ie. tel:+61399389998;phone-context=national , tel:+61399389998) this should only be counted as 1 customer.

       

       

      Data:  

      CSD.Customer Formatted Number# Offered
      tel:+61399389998;phone-context=national39
      tel:+61399389998;phone-context=national23
      tel:+61399389998;phone-context=national2
      tel:+61399389998;phone-context=national1
      tel:+61399389998;phone-context=national0
      tel:+613993899985
      tel:+613993899984
      tel:+613993899981
      sip:0anonymous@anonymous.invalid654
      sip:0anonymous@anonymous.invalid216
      sip:0anonymous@anonymous.invalid77
      sip:0anonymous@anonymous.invalid29
      christopher.w@yahoo.com5

       

      Expected Result:

      Repeat Callers
      tel:+613993899981
      sip:0anonymous@anonymous.invalid1
      christopher.w@yahoo.com1