3 Replies Latest reply on Jul 26, 2018 12:52 PM by Joe Oppelt

    Multiple Choice Field in Tableau not calculating all choices.

    shontia Terry

      I have a multiple choice field I'm exporting from SharePoint into a Tableau

       

      My issue is that I cannot seem to separate the different choices in the

      field to get accurate data.

       

      Example:

      SubmitterDateDef Cause Code
      Shontia7/20/2018HS2 Equipment; LS3 Training; GF5 Guidance
      Susan7/21/2018LS3 Training; FS1 Vacation; Hs2 Equipment

       

      Tableau will only count or pick up the first choice in Cause Code field. It

      is not counting the additional field choices.

      I tried writing a calculation of IF ELSE, but only the first choice in the

      field is getting calculated.

       

      Any assistance would be greatly appreciated. (Workbook attached)