4 Replies Latest reply on Mar 29, 2018 5:37 AM by geryn.ligator

# Donut Chart that is Over 100%

Hello,

I am using a donut chart to show what percent we are to goal.

In the case that the goal is reached (100% and above), is there a way to make the whole chart remain one color?

I want to avoid confusion of the number saying we are above goal and the graphic looking like we are still approaching it.

Thanks!

• ###### 1. Re: Donut Chart that is Over 100%

Geryn,

I would just replace your metric with an IF/THEN statement similar to this:

IF [Metric %] >1 THEN 1 ELSE [Metric %] END

This will cap the value at 100%

-Wesley

If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 2. Re: Donut Chart that is Over 100%

Would this still allow the donut to show the percentage of the goal we are at? Ie- if we are at 75% of goal, I want the donut to be 75% one color and 25% another color.

Are you able to show me an example of what you are talking about in the sample workbook I attached.

Thanks!

• ###### 3. Re: Donut Chart that is Over 100%

Geryn,

I only have access to Tableau 10.3, so I had to create my own file with Superstore data, but I've attached an example of how this would work.

I recreated the situation with a Sales Target and a % of Target that is both above and below 100%. The calculation you would use is the [% of Sales Target with Cap].

-Wesley

If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful