2 Replies Latest reply on Jun 24, 2013 8:28 AM by Ethan Weiss

    Removing duplicate calls within a giving range

    Ethan Weiss

      Hi All -

      I want to get total calls, however the issue is that sometimes a caller gets disconnected, etc. and calls back. I don't want to include that as 2 calls but as 1.

       

      I think I would use the following criteria but have no idea where to start in Tableau...

       

      Compare

      • DOB
      • patient last name
      • created (UNIX timestamp) - I would have a range of up to 5 minutes between calls. So if someone calls back within 5 minutes dont count. If calls over 5 minutes count.

       

      So for example, in the attached workbook I would count row 2 and 3 as only one instance. 

       

      Any ideas?????????