6 Replies Latest reply on Jan 22, 2019 7:20 PM by Rodrigo Calloni

# How to create Doughnut Chart with two percentages?

Hi, I am
trying to create two simple doughnut charts with two calculations I've made.
One is a percentage of around 70% and the other is around 25%. I would ideally
like something

• ###### 2. Re: How to create Doughnut Chart with two percentages?

Hi Tgvr,

To achieve this, you would have to create two charts/sheets and bring them into one dashboard later.

Just reverse the color of the percentages.

1. In the first sheet, drag the color filed into Color and give 75% as the red color.

2. Create a duplicate of the color filed, and give 25% as the red color. Creating a duplicate color field is important, since you cannot use the same field to have different colors in different charts.

Labels, you can have different in each of the doughnuts.

Thanks,

Amar.

• ###### 3. Re: How to create Doughnut Chart with two percentages?

Hello

What you need is to create the two slices in a unique dimension. You can do this by grouping the original dimension, or create a calculated field with a IF THEN ELSE statement to define the wins with triple doubles and others as else.  You can then do the opposite for the wins without triple double.

Then you need to follow the techniques available to create donuts (pie chart + circle double axis) and place the % text that you have calculated in the Circle one.

Attached and example I did with Superstore.

I hope this helps.
Rodrigo

• ###### 4. Re: How to create Doughnut Chart with two percentages?

Hi,

regards,

venkat

• ###### 5. Re: How to create Doughnut Chart with two percentages?

Hi

If you download the worbook that I attached you can get the logic I used in Superstore dataset.

I hope this helps

Rodrigo

• ###### 6. Re: How to create Doughnut Chart with two percentages?

Hi Rodrigo,

I will take a look at it. I am looking to have a separate repository that can be linked to the dashboard. I am willing to chart if you are available for better explanation.

Thank you

• ###### 7. Re: How to create Doughnut Chart with two percentages?

Hi Nana