Forum Discussion

Haya's avatar
Haya
Helper II
6 years ago
Solved

Values without aggregation in pie chart

I have a table with Employee name, tasks, % completion 

I want to visualize it in pie chart.

Employee name as Legend, tasks as details, % completion as values.

 

However, when I put % completion in values it is converted to "count of % completion" . I wanted to presented as it is without aggregation.

 

 

 

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Haya ,

     

    For the numeric data, there is default aggregation to display the value. To render the original value of % completion , you can right click to choose aggregation "Sum", turn on "Detail labels", choose "Data value".

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

8 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Haya ,

     

    What is data type of %Completion field? Make sure it is in Numeric value(Whole Value or Decimal value).

     

    Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!

    • Haya's avatar
      Haya
      Helper II
      6 years ago

      It is Decimal Number.

      Format: Percentage

       

      • mussaenda's avatar
        mussaenda
        Community Champion
        6 years ago

        hi Haya , if it's a percentage already, where is the value it was computed?

        that what you need to put in values and show values as % of GT.

  • mussaenda's avatar
    mussaenda
    Community Champion
    6 years ago

    You can take the completion values and make its how value as % of GT. Right click the value, then you will find it there

    • Haya's avatar
      Haya
      Helper II
      6 years ago

      Thanks for your response mussaenda 

      it makes it "GT of count % Complete"

      So it is not the solution. it still use count.

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Haya ,

     

    For the numeric data, there is default aggregation to display the value. To render the original value of % completion , you can right click to choose aggregation "Sum", turn on "Detail labels", choose "Data value".

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Haya's avatar
      Haya
      Helper II
      6 years ago

      Thanks v-xicai  it was helpful.

      However, it ignores the rows with "0 % completion", is there a way to visualuze tasks with 0 %completion?

      • v-xicai's avatar
        v-xicai
        Community Support
        6 years ago

        Hi Haya ,

         

        You may try to enable the option "Show items with no data" in following location.

         

         

         

         

         

         

        Best Regards,

        Amy

         

        Community Support Team _ Amy

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.