1 Reply Latest reply on Feb 22, 2016 1:37 PM by Shinichiro Murakami

    How to add additional column to my charts

    James Negri

      I've got kind of a tricky issue:

       

      I have 5 Tableau files showing answers from a survey.

      • In each file I made a pivot field out of most of the data columns, then made groups from the pivot field names.
      • Each file has about 120 groups Each file's dashboard has about 30-50 bar graphs.
      • Each bar graph shows the responses for one of the survey questions.
      • Some respondents didn't answer all questions, so my spreadsheet has blank cells sprinkled all over it from these null responses.
      • The Excel files are kinda big - 600 column, 700 rows.

      Here's my problem:

       

      For every bar graph, I need to show the % and number of null responses. This could be shown as an additional column for each graph, or a text item somewhere in the graph, maybe below the title.

      To add a column to each graph I'd have to:

      • Go back into Excel and make a "Not Answered" column for each of my 200+ questions
      • Then add them to my pivot fields, and drag each one into its corresponding pivot field group. The problem with this approach is, basically, that I am mortal and would expect to die of old age before I finish.

       

      Or... I could find a way to make a calculated field that finds the % and quantity of Not Answered and display that in each graph.

      I can't figure out how to sum the %'s and quantities across all the columns of my graph, then subtract that from the number of respondents (which is a hard number that I've made into a parameter in each file.)

      I also don't see any way to add this to my graph as a text item.

        • 1. Re: How to add additional column to my charts
          Shinichiro Murakami

          I looked though your data and below is my comment.

           

          I recommend that you change the data structure significantly.

          I prepared two more calculated fields to group

           

          Weekly, Bi weekly, Monthly type of time period factor

          and

          Question Group Like Cllab with Office

           

           

          [Pivot Field Group title 2]

          left([Pivot field names],find([Pivot field names],"$")-1)

           

          [Pivot Field Group]

          if contains([Pivot field names],"Daily") then "Daily"

          elseif contains([Pivot field names],"Weekend") then "Weekend"

          elseif contains([Pivot field names],"Monthly") then "Monthly"

          elseif contains([Pivot field names],"Bi-weekly") then "Bi-weekly"

          elseif contains([Pivot field names],"Weekly") then "Weekly"

          elseif contains([Pivot field names],"Rarely") then "Rarely"

          END

           

          Now you can handle all the data more flexibly...