10 Replies Latest reply on Oct 20, 2016 12:05 AM by Carl Slifer

# Calculated field to show circle fill

Can anyone help me achieving this through calculated fields?

• ###### 1. Re: Calculated field to show circle fill

Hi Shahana,

There is not a set of shapes that does this naturally. You will need to create your own set of custom shapes and import them into tableau. 10 shapes or less will probably be enough. Then you will have to create a calculated field that checks your current percentage returning calculated field. It would be something like...

INT([Current Calc Field] * 10) This will return 0-10 as your values (assuming your max value is 100%)

You will then be able to assign this calculated field results to the shapes 0-10. This would mean you would need to handpick the shape for 0 (0-9%), 1 (10 - 19%), And so on.   Custom Shapes | Tableau Software

Best Regards,

Carl Slifer

InterWorks

1 of 1 people found this helpful
• ###### 2. Re: Calculated field to show circle fill

Thanks, I didn't know it was this complicated. I remember watching one of the videos online where a Tableau Jedi created a calculated field and moved it on to color to show fill and percentage. I cannot find it now.

Anyway, thanks for the help!

• ###### 3. Re: Calculated field to show circle fill

It is not exactly what you are looking for; but one alternative that could be done without adding shapes is a donut chart.

• ###### 4. Re: Calculated field to show circle fill

I was trying to achieve this...I can create the donut chart but cannot fill the circle color relative to the %.

Thanks!

• ###### 5. Re: Calculated field to show circle fill

Maybe you could just use a pie chart or a stacked bar chart, and each of those would just have two segments, It's not exactly what you want, but could achieve the same effect.  PercentFull and PercentEmpty.  And PercentFull would be some sort of calculation based on your data, and PercentEmpty would probably just be 1-[PercentFull].

For example, a pie chart might look like:

And a stacked bar might look like this:

• ###### 6. Re: Calculated field to show circle fill

Hi.

It seems more like Qlik Sense.

I never saw a pie chart be filled except in angle format.

Using formats seems a better option.

• ###### 7. Re: Calculated field to show circle fill

Tableau tends to limit 'bad' visualization practices, and promote (make easy) better visualization practices. Our forums tend to take all questions as a 'challenge' -- essentially helping you create the viz you are wanting to create without considering whether the viz 'type' has any real value. In your case, combining a donut chart with a filled circle chart might be one of the worst data visualization concepts I can think of -- almost impossible to 'decode' by humans.

So while we all love a challenge, and tend to offer contorted/complex answers to questions about 'charts' that are difficult to create in Tableau, I would suggest that the scientists at the core of Tableau, have done this on purpose. (Think of 3-D charts as an example.)

If you don't understand anything I'm talking about, then use the answer above that gets you closest to your goal.

Cheers,

--Shawn

• ###### 8. Re: Calculated field to show circle fill

Could only make it half full :-)

• ###### 9. Re: Calculated field to show circle fill

Nice!  But being the pessimist that I am I'd argue that it's half empty :-)

• ###### 10. Re: Calculated field to show circle fill

It's twice as big as it needs to be is what the engineeer in me would say.

On Thursday, 20 October 2016, Ivan Young <tableaucommunity@tableau.com>