1 Reply Latest reply on Jun 26, 2018 4:49 AM by Zhouyi Zhang

    Matching using different methods


      Hi All I would like to find matching values using different dimensions and count finding repeat customer


      For example


      If Basecustomer Id match





      Phone Number (Mobile OR Landline)




      Email  ignoring any email with the following words ( 'noemail%' , 'nomail%' )




      (First name + Last name + Postcode Match)





      How do I create a calculation that will consider all the above conditions?


      I am just counting for each year say 2000 -2018


      How many previous were matching with the above conditons ...