Values without aggregation in pie chart

[Haya]

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.

[v-xicai · Accepted solution]

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]

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]

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.

[mussaenda]

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]

Thanks for your response @mussaenda 

it makes it "GT of count % Complete"

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

[Tahreem24]

@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]

It is Decimal Number.

Format: Percentage

[mussaenda]

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.