1 2 Previous Next 15 Replies Latest reply on May 8, 2018 3:55 AM by Marija Zivkovic

# Chart with circle in the circle

Hi,

Can anyone has idea how to build this type of chart? Like circle in the circle, where smaller circle is part of bigger and bigger..and the biggest circle is actually 100%?

Thanks,

Marija

• ###### 1. Re: Chart with circle in the circle

Hi Marija

I am not a specialist of polygon chart, but try.

Not 100% sure, but I am afraid that using circle size does not bring exact location and size to match the circumference at bottom

You can put each circle's value on this

Thanks,

Shin

1 of 1 people found this helpful
• ###### 2. Re: Chart with circle in the circle

Here is one more solution in the attached workbook.

1 of 1 people found this helpful
• ###### 3. Re: Chart with circle in the circle

Hi  Shinichiro,

Thanks a lot! That is excactly view that I need.

I am new in Tableau, so not sure how to apply this work on my data?

In attach is sample of my data, where for example biggest circle should be Total, lesser L Avail.. etc.

Once again, thanks a lot for your support!

Marija

• ###### 4. Re: Chart with circle in the circle

Hi Hari,

Thank you but I can not open this version. Suppose it is because I have 10.3?

Thanks,

Marija

• ###### 5. Re: Chart with circle in the circle

Yes, the workbook I provided can be opened using 10.5.

• ###### 6. Re: Chart with circle in the circle

Reshape data like this.

Track ID 1~100

And same approach as my example.

Thanks,

Shin

• ###### 7. Re: Chart with circle in the circle

Thank you a lot!

I really appreciate!

Thanks,

Marija

• ###### 8. Re: Chart with circle in the circle

HI Marija

this is little it complicated and I think you need to spend some time to digest.

If you have further question,s feel free to post new thread.

Thanks,

Shin

• ###### 9. Re: Chart with circle in the circle

Hi  Shinichiro,

I am working on this chart, but I can not replicate what you get.

Do you have idea where I am making an error?

Thanks,

Marija

• ###### 10. Re: Chart with circle in the circle

HI Marija,

or

"Phase" is not a calculated field and I don't know what is this.

But anyways, circle ID (sum phase) need to be added in the view, and if you need "Phase" description,  these need to be added in to colors.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 11. Re: Chart with circle in the circle

Thanks, you are the best!

Can I show sum of Total/Available.. instead of max value?

Also, I am getting this line for X axes, not sure why.

Thanks,

Marija

• ###### 12. Re: Chart with circle in the circle

I don't understand which field is " sum of Total/Available.."  and "Max value".

As long as that is aligned with circle ID, you can change to sum phase to that field.

Thanks,

Shin

• ###### 13. Re: Chart with circle in the circle

This calculation gives me Max value for Y but I want to show sum for all circle (for total, available..etc)

For example, I don't want to show as label 72. Instead of that I want sum summ of total market - 167 (which should be size of the circle)

Thanks,

Marija

• ###### 14. Re: Chart with circle in the circle

I cannot support for very complicated data set.

Current assumption is that you have all the circle data as record level and I was not assuming any calculation to determine the size of circle.

It's getting complicated because it's completely different topic. and could you post new thread with clarifying the issues.

It's better for you and all the community people who refer this post to close the issue with single step.

Thanks,

Shin

1 2 Previous Next