8 Replies Latest reply on Jan 3, 2017 10:27 AM by Ritu Poola

    How to show both label and percentage in KPI Donut

    Ritu Poola

      Hi,

       

      I am new to the Tableau and looking solution as required. My data is as shown below.

      There are 500 Student ids no duplicate ids and  assigned to subject like Maths,Science,Computer,Sports. These 4 subjects are fixed and repetitive  for different type of student ids ( not same student id)

       

      Student IDSubject
      1Maths
      2Science
      3computer
      4Sports
      ..
      ..
      500like any one above subject

       

      Solution needed in donuts in KPI view for below requirement

      Consider example like subject as Maths and assigned number of students are 150 then, in this case i need to show 3 items in the donut  KPI

       

            a) Different colour for total 500 students and angle should change and it should change as per  Percentage  i.e 30 % ( 150/500) in Maths critaria

            b) In Middle of the donuts need to show both labels text like 30% and 150 students.

            c) If we put Subject as column after dummy place holders then 4 donuts should visible like Maths,Science,Computer,Sports and donuts vary

      with % in angle and Middle of the donuts should have  number of students and percentage.

       

      I am not getting the exact KPI view. sample view look like below

       

       

      Please provide your inputs and solution possibilities.

      Thanks

      Ritup