9 Replies Latest reply on Nov 28, 2018 3:52 PM by swaroop.gantela

# Radial Pie Chart Problems

I am a Tableau 10.5 desktop user trying to build a radial pie chart following a video I found online.  I am able to format my data and create calculated fields, but half way through building the chart I am getting errors.  I'm hoping someone can tell me where I'm making mistakes.  I have attached a twbx file and screen shots below.

I am trying to build something like this but with 4 rings

Here's my data

At Step 3 -- When I change the X and Y to compute using the Path Bin, I am not getting the inner ring as shown in the video

Step 4:  I am able to change the chart type to polygon, but it does not look the same (most noticeable on lower left quadrant).

Step 5:  When I place the "Index" measure to the Path on the Marks card, the viz disappears completely.

• ###### 1. Re: Radial Pie Chart Problems

Teresa,

I think there was a typo in the X and Y calcs.

The last few * signs should be +

IF [Index]< 270 THEN

SIN([Index]*[WC_Percentage]*[WC_PI]/180)*[WC_Start]

ELSEIF [Index]> 270 THEN

SIN((540-[Index])*[WC_Percentage]*[WC_PI]/180)*([WC_Start]    +    1)

ELSE

SIN(([Index]*[WC_Percentage]+3)*[WC_PI]/180)*([WC_Start]    +  0.5)

END

I went past that point, but the order of bars seemed off.

Please see workbook v10.5 attached in the Forum Thread.

1 of 1 people found this helpful
• ###### 2. Re: Radial Pie Chart Problems

Thank you Swaroop!  I corrected my calculations and the chart did appear.  Like you, my circles are not sorting from smallest in center to largest in outer ring.  Does anyone have ideas why this would be happening?  I am pasting a link below to the video I watched.  Could it be the data must be sorted in a specific order before you try to build the viz?

Expected Result:

My Result

• ###### 3. Re: Radial Pie Chart Problems

Teresa,

It does appear that the arrangement has been predetermined in the datasource by the [Order Field].

I wrote a calculated field to rearrange them by rank:

RANK(MAX([Expense]),'asc')

I replaced the [Order] references with this rank

(using right-click, replace references).

This had a table calculation setting of

Compute Using: Program.

These are nested in the tablecalc settings for x and y as well

and needed to be likewise set to Program.

This is described more in this link:

Tableau Rings - Toan Hoang

Please see workbook v10.5 attached in the Forum Thread.

2 of 2 people found this helpful
• ###### 4. Re: Radial Pie Chart Problems

Thank you Swaroop for your suggestions which helped me create the desired radial pie chart.

Ta Da!

Here is the You Tube Video that started it all.  Very good instructions, however the video was out of focus when I expanded to full screen.  Nevertheless, it is the best set of instructions I found for a "non-math person" such as myself.

TABLEAU RADIAL PIE GAUGE CHART TUTORIAL - YouTube

I would also note that the radial pie requires making a duplicate copy of your data.  This doubled my Expense data, so I needed an additional calculated field to use for my labels.

Thanks again!

• ###### 5. Re: Radial Pie Chart Problems

Teresa,

Glad you achieved your desired chart.

All the best.

• ###### 6. Re: Radial Pie Chart Problems

Hello, I am having a radial pie chart issue.  I have everything working correctly except for the coloring.  I created the chart slightly different in order for the chart to be dynamic when adjusting a filter.  The problem that I have is that the coloring doesn't adjust correctly.  The acceptance rate is showing correctly but the offer rate is not.  The measure values are driving the color which is pct2 and remainder2.  I think I need to create a calculated field but not sure what the calculation should be or maybe I need to do something entirely different.  Any help would be greatly appreciated.

• ###### 7. Re: Radial Pie Chart Problems

Damien,

My apologies, I wasn't able to mock up your screenshot.

Would you be able to post a simplified version of your workbook with fake data?

• ###### 8. Re: Radial Pie Chart Problems

Sure, attached is some dummy data.  The version attached looks good when only 1 program is selected.  When multiple programs are selected, the color and graphs get very messy.  The graphs look cool but I need to be able to select more than 1 program and have the graphs update appropriately.  Any help would be appreciated.  Thanks

• ###### 9. Re: Radial Pie Chart Problems

Damien,

Thanks for the sample workbook; it is a cool looking visualization.

I'm not sure if I'm on the right track, but it felt to me that I needed to

add [Program] to the detail shelf. It seemed like otherwise the pie parts

were overlapping?

For the color, I added [Bigness] to the color shelf which allowed a separate

color for Accept and Offer.

A problem arose with the Offer Rate label on the Text shelf.

If it is set as a Dimension, I think that it only showing one offer rate.

As an Attribute, it shows multiple rates, but it also labels the Remainder parts.

Because the is coming off of Measure Values, we can't separately

say only show the label for the [pct2] part.

One possible way to handle this might be if the Pct and Remainder could be

pivoted into one column. Then we could tell it to label only one Pivot Field Name.

But it will take a few extra steps to get the pie working (namely an LOD for the Remainder).

I wasn't able to connect to the datasource, but do you think pivoting might be a possibility?

Please see workbook v10.5 attached in the Forum Thread.