4 Replies Latest reply on Aug 16, 2016 8:15 AM by Vincent Baumel

    How to include percentage to dynamically changing pie chart?

    Maheshh C K

      Dear All,

      My requirement is to dynamically add percentage to a pie
      chart with the data’s flowing in when filters are given to end user.

      Input:

      Row#

      Viewpoint

      Category

      Attribute

      Rating

      1

      V1

      C1

      A

      High

      2

      V1

      C2

      A

      Low

      3

      V2

      C1

      A

      Medium

      4

      V2

      C2

      A

      Low

      5

      V1

      C1

      B

      Medium

      6

      V1

      C3

      B

      High

      7

      V2

      C3

      B

      High

      8

      V2

      C2

      B

      Medium

      9

      V1

      C1

      C

      Low

      10

      V1

      C2

      C

      Low

      11

      V2

      C2

      C

      High

       

      Pie chart is made on the count of distinct Attribute against
      Rating

      The filters (Viewpoint, Category)
      are shown to the end user. The percentage of each rating to be displayed along
      with the distinct count of the Attribute.

      I tried table calculation but the percentage is taken on the
      total table count when filtered it is showing more than 100% when calculated.

      Also on a separate note, I got stuck in making a pie chart
      with combined Viewpoint, Category & Attribute which is a combined primary
      key.

      Am a newbee to Tableau. Kindly help me on the same.

       

      Thanks

      Maheshh