4 Replies Latest reply on Jun 25, 2015 2:30 AM by Sankarmagesh Rajan

Pie chart based on measure "% of budget reached"

Hi all,

I all new to Tableau.

I saw this great design which I would like to copy - but I don't know how to do it.

What I want is a pie chart which shows how much of the turnover has been reached.

The measure is already calculated, and is fx 20%, meaning that the product group is 20% from the budget turnover.

How would it be easiest to do this? I would like to end up with a result like the attached top 4 pie charts.

Hope to hear from you guys!

Kind regards,

Steffen

• 1. Re: Pie chart based on measure "% of budget reached"

Hi

This is the donut chart.

Step1:

We can create one calc  as one.

Step 2:

Create pie chart with product and sales.

Step3:

Drag this one calc into coloumn two times and select dual axis.

Step4:

Un check aggregation in analysis menu.

Step 5:

Step6:

Select first one field in marks section and increase size of pie.

step7:

Drag the Product into colour and sales into label.

Step 8:

Select another one calc in marks and drag the new calculated total sales into label

-select mark as circle

-change colour as white

-Select size and reduce size

see image

• 2. Re: Pie chart based on measure "% of budget reached"

Hi Steffen,

I have attached the donut chart workbook.

version 8.3

Thanks

sanakr

• 3. Re: Pie chart based on measure "% of budget reached"

Hi Sankar,

Thank you for trying, but I don't understand your go through - I am sorry

When I try to follow your steps, I end up with something like what you see on the attached picture.

Kind regards,

Steffen

• 4. Re: Pie chart based on measure "% of budget reached"

Hi Steffen,

See my attached image in previous post. One measure added pie chart and another selected as circle and reduced the size of circle.

see the marks card sum(one) and another sum(one). select 2nd one and change it as circle and reduce size via size mark.

Thanks

sankar