12 Replies Latest reply on Apr 25, 2018 1:08 PM by Jessica Hughes

    Counting Split columns

    Jessica Hughes

      Hello,

       

      I have a column in my excel file that is written to have multiple drop down choices. This document is a living document, constantly being updated -- so I can't just perform the split in the excel, I am needing to do it in Tableau.

       

      I have successfully split them in Tableau

      I then wrote the following formula:

      IF [Intervention 1] = 'Care coordination' THEN 'Care Coordination'
      ELSEIF [Intervention 2] = 'Care coordination' THEN 'Care Coordination'
      ELSEIF [Intervention 3] = 'Care coordination' THEN 'Care Coordination'
      ELSEIF [Intervention 4] = 'Care coordination' THEN 'Care Coordination'
      ELSEIF [Intervention 5] = 'Care coordination' THEN 'Care Coordination'
      ELSEIF [Intervention 6] = 'Care coordination' THEN 'Care Coordination'
      ELSEIF [Intervention 7] = 'Care coordination' THEN 'Care Coordination'
      ELSEIF [Intervention 8] = 'Care coordination' THEN 'Care Coordination'
      ELSEIF [Intervention 9] = 'Care coordination' THEN 'Care Coordination'

      ELSEIF [Intervention 1] = 'PCP collaboration' THEN 'PCP collaboration'
      ELSEIF [Intervention 2] = 'PCP collaboration' THEN 'PCP collaboration'
      ELSEIF [Intervention 3] = 'PCP collaboration' THEN 'PCP collaboration'
      ELSEIF [Intervention 4] = 'PCP collaboration' THEN 'PCP collaboration'
      ELSEIF [Intervention 5] = 'PCP collaboration' THEN 'PCP collaboration'
      ELSEIF [Intervention 6] = 'PCP collaboration' THEN 'PCP collaboration'
      ELSEIF [Intervention 7] = 'PCP collaboration' THEN 'PCP collaboration'
      ELSEIF [Intervention 8] = 'PCP collaboration' THEN 'PCP collaboration'
      ELSEIF [Intervention 9] = 'PCP collaboration' THEN 'PCP collaboration'

      ELSEIF [Intervention 1] = 'Medication Management' THEN 'Medication Management'
      ELSEIF [Intervention 2] = 'Medication Management' THEN 'Medication Management'
      ELSEIF [Intervention 3] = 'Medication Management' THEN 'Medication Management'
      ELSEIF [Intervention 4] = 'Medication Management' THEN 'Medication Management'
      ELSEIF [Intervention 5] = 'Medication Management' THEN 'Medication Management'
      ELSEIF [Intervention 6] = 'Medication Management' THEN 'Medication Management'
      ELSEIF [Intervention 7] = 'Medication Management' THEN 'Medication Management'
      ELSEIF [Intervention 8] = 'Medication Management' THEN 'Medication Management'
      ELSEIF [Intervention 9] = 'Medication Management' THEN 'Medication Management'

      ELSEIF [Intervention 1] = 'Social care giver support' THEN 'Social care giver support'
      ELSEIF [Intervention 2] = 'Social care giver support' THEN 'Social care giver support'
      ELSEIF [Intervention 3] = 'Social care giver support' THEN 'Social care giver support'
      ELSEIF [Intervention 4] = 'Social care giver support' THEN 'Social care giver support'
      ELSEIF [Intervention 5] = 'Social care giver support' THEN 'Social care giver support'
      ELSEIF [Intervention 6] = 'Social care giver support' THEN 'Social care giver support'
      ELSEIF [Intervention 7] = 'Social care giver support' THEN 'Social care giver support'
      ELSEIF [Intervention 8] = 'Social care giver support' THEN 'Social care giver support'
      ELSEIF [Intervention 9] = 'Social care giver support' THEN 'Social care giver support'

      ELSEIF [Intervention 1] = 'Member education' THEN 'Member education'
      ELSEIF [Intervention 2] = 'Member education' THEN 'Member education'
      ELSEIF [Intervention 3] = 'Member education' THEN 'Member education'
      ELSEIF [Intervention 4] = 'Member education' THEN 'Member education'
      ELSEIF [Intervention 5] = 'Member education' THEN 'Member education'
      ELSEIF [Intervention 6] = 'Member education' THEN 'Member education'
      ELSEIF [Intervention 7] = 'Member education' THEN 'Member education'
      ELSEIF [Intervention 8] = 'Member education' THEN 'Member education'
      ELSEIF [Intervention 9] = 'Member education' THEN 'Member education'

      ELSEIF [Intervention 1] = 'Benefit assistance' THEN 'Benefit assistance'
      ELSEIF [Intervention 2] = 'Benefit assistance' THEN 'Benefit assistance'
      ELSEIF [Intervention 3] = 'Benefit assistance' THEN 'Benefit assistance'
      ELSEIF [Intervention 4] = 'Benefit assistance' THEN 'Benefit assistance'
      ELSEIF [Intervention 5] = 'Benefit assistance' THEN 'Benefit assistance'
      ELSEIF [Intervention 6] = 'Benefit assistance' THEN 'Benefit assistance'
      ELSEIF [Intervention 7] = 'Benefit assistance' THEN 'Benefit assistance'
      ELSEIF [Intervention 8] = 'Benefit assistance' THEN 'Benefit assistance'
      ELSEIF [Intervention 9] = 'Benefit assistance' THEN 'Benefit assistance'

      ELSEIF [Intervention 1] = 'Self-Management education' THEN 'Self-Management education'
      ELSEIF [Intervention 2] = 'Self-Management education' THEN 'Self-Management education'
      ELSEIF [Intervention 3] = 'Self-Management education' THEN 'Self-Management education'
      ELSEIF [Intervention 4] = 'Self-Management education' THEN 'Self-Management education'
      ELSEIF [Intervention 5] = 'Self-Management education' THEN 'Self-Management education'
      ELSEIF [Intervention 6] = 'Self-Management education' THEN 'Self-Management education'
      ELSEIF [Intervention 7] = 'Self-Management education' THEN 'Self-Management education'
      ELSEIF [Intervention 8] = 'Self-Management education' THEN 'Self-Management education'
      ELSEIF [Intervention 9] = 'Self-Management education' THEN 'Self-Management education'

      ELSEIF [Intervention 1] = 'Care management referral' THEN 'Care management referral'
      ELSEIF [Intervention 2] = 'Care management referral' THEN 'Care management referral'
      ELSEIF [Intervention 3] = 'Care management referral' THEN 'Care management referral'
      ELSEIF [Intervention 4] = 'Care management referral' THEN 'Care management referral'
      ELSEIF [Intervention 5] = 'Care management referral' THEN 'Care management referral'
      ELSEIF [Intervention 6] = 'Care management referral' THEN 'Care management referral'
      ELSEIF [Intervention 7] = 'Care management referral' THEN 'Care management referral'
      ELSEIF [Intervention 8] = 'Care management referral' THEN 'Care management referral'
      ELSEIF [Intervention 9] = 'Care management referral' THEN 'Care management referral'

      ELSEIF [Intervention 1] = 'Customer service referral' THEN 'Customer Service Referral'
      ELSEIF [Intervention 2] = 'Customer service referral' THEN 'Customer Service Referral'
      ELSEIF [Intervention 3] = 'Customer service referral' THEN 'Customer Service Referral'
      ELSEIF [Intervention 4] = 'Customer service referral' THEN 'Customer Service Referral'
      ELSEIF [Intervention 5] = 'Customer service referral' THEN 'Customer Service Referral'
      ELSEIF [Intervention 6] = 'Customer service referral' THEN 'Customer Service Referral'
      ELSEIF [Intervention 7] = 'Customer service referral' THEN 'Customer Service Referral'
      ELSEIF [Intervention 8] = 'Customer service referral' THEN 'Customer Service Referral'
      ELSEIF [Intervention 9] = 'Customer service referral' THEN 'Customer Service Referral'
      END

       

      It's a valid formula and I'm getting results, it's just for some reason, the numbers aren't right. I know it's a dimensions calculation, but I was hoping that "Number of Records" would count the number of times it would see the particular phrase.

      My suspicion is that it is only counting Intervention 1. Care Coordination is the only outcome that is correct and it is the first option to select in the drop down (meaning it tends to be first in the list and would be Intervention 1).

       

      How do I write a formula that will calculate all Interventions Splits correctly?

       

      Thank you!