2 Replies Latest reply on Dec 13, 2016 5:28 PM by siyang.teo

    Create pie chart with a single percentage value

    siyang.teo

      Hi. My database table after aggregation in Tableau produces the following table with the percentage for each category listed below.

       

      I want to create 4 pie charts, one for each category using those percentage values.

       

       

      CategoryTotal CountCountMissingPercentage Count
      A57,69613,05544,64122.63%
      B268,22454,474213,75020.31%
      C538,53680,047458,48914.86%
      D540,168127,609412,55923.62%

       

       

      However, from what I understand, I will probably need to add a new row for every category showing the remainder percentage for each category before I can generate the pie charts.

       

       

      CategoryTotal CountCountMissingPercentage Count
      A57,69613,05544,64122.63%
      A77.37%
      B268,22454,474213,75020.31%
      B79.69%
      C538,53680,047458,48914.86%
      C85.14%
      D540,168127,609412,55923.62%
      D76.38%

       

      Does anyone know how to do this? Or any other manipulations from the original table?

       

      Thank you!