3 Replies Latest reply on Aug 13, 2018 8:25 PM by swaroop.gantela

    Dynamic matching

    Angela Rachubinski

      Hello!

      I’d like to be able to match individuals from Cohort A with individuals from Cohort B, based on gender and closest age match (+/- 5 years). Each individual in Cohort B can only be matched with one person in Cohort A ('Original' example sheet in attached workbook). These pairings will shift as we continually add more individuals into the database (see 'Expanded' example sheet in the workbook with expected matches).

       

      Is there a way to write this as a calculated field in Tableau? Right now, all I need is a boring output table as a product. Or is this something that would have to be pre-processed in R or Python?

       

      Thanks in advance for any suggestions!

       

      Angela

      Tableau 2018.2