5 Replies Latest reply on Apr 3, 2018 9:40 AM by Jim Dehner

    Sum of variables across multiple dimensions

    Kevin Slattery

      Hello! Don't know if I'm explaining this issue accurately via the title, but:

       

      -I have different dimensions in my data for program referrals from a nonprofit -- it's represented as Referral1, Referral2, Referral3, etc. Some entries may have six different referrals, others may have none. The possible types of referrals & their labels don't change (i.e. "preschool" or "support group") but the order they're in & whether or not a referral is given may change.

       

      In its original form in Excel, it would look like this:

       

       

      Participant ID#Referral1Referral2Referral3
      1234Home VisitingPreschoolSupport Group
      5678PreschoolWelfare Assistancenull
      8909Support Groupnullnull
      5545nullnullnull

       

       

       

      I can't figure out in Tableau how to get a simple sum of the # of times "Preschool" occurs throughout all the referrals combined. Trying to do a table calculation but can't seem to get it right.