Half-Circle Charts in Tableau

Now we are in the full swing of things I wanted to create a nice and simple visualisation for comparing two different metrics i.e. through drawing two half-circles and comparing them against each other. In this tutorial, we will go through the process of creating this visualization in a simple step-by-step manner.

Note: As always never choose a data visualisation type and try to fit your data into it, instead, understand your data and choose the best visualization for your data consumers.

Data

Load the following data into Tableau Desktop / Public.

Note: we need two records for each stage as we are going to be drawing polygons and using densification to get more points on our canvas.

Calculated Fields

With our data set loaded into Tableau, we are going to create the following Calculated Fields and Bins:

Path (bins)

• Right click on Path, go to Create and select Bins…
• In the Edit Bins dialogue window:
  • Set New field name to Path (bin).
  • Set Size of bins to 1.
  • Click Ok.

Index

INDEX()-1

Product Flag

WINDOW_MAX( IIF(MAX([Product])="Office",-1,1))

TC_Max Sales

WINDOW_MAX(MAX({ FIXED : MAX([Sales]) } ))

TC_Product Sales

WINDOW_MAX(MAX([Sales]))

TC_Percentage

[TC_Product Sales]/[TC_Max Sales]

X

SIN([Index]*PI()/180)*[TC_Percentage]*[Product Flag]

Y

COS([Index]*PI()/180)*[TC_Percentage]*[Product Flag]

So with our Calculated Fields in place, let us start creating our worksheet.

Worksheet

We will now build our worksheet:

• Change the Mark Type to Polygon.
• Drag Product onto Color Mark.
• Drag Path (Bins) onto Rows.
  • Right-click on the object and ensure that Show Missing Values is checked.
  • Drag this object onto the Path Mark.
• Drag X onto Columns.
  • Right-click on the object, go to Using and select Path (Bins).
• Drag Y onto Rows.
  • Right-click on the object, go to Using and select Path (Bins).

You should get something like the following:

We will now adjust the worksheet by:

• Copying X, setting Dual Axis and turning the copy into a Line Chart.
• Double click the X-axis and fixing the values to be from -1.1 to 1.1.
• Remove the grid and axis lines.
• Edit the polygon transparency 60%.
• Hide the headers.
• Adjust the tooltip.

You want to end up with the following:

and boom, we are done, we have created an interesting way of comparing two different metrics using half circles.

You can see and interact with my visualisation on Tableau Public at https://public.tableau.com/profile/toan.hoang#!/vizhome/Half-Circles/Half-Circles

Summary

I hope you all enjoyed this article as much as I enjoyed writing it, if so, please do share this article with fellow Tableau addicts and spread the love. Do let me know if you experienced any issues recreating this Visualisation, and as always, please leave a comment below or reach out to me on Twitter @Tableau_Magic.

If you like our work, do consider supporting us on Patreon, and for supporting us, we will give you early access to tutorials, exclusive videos, as well as access to current and future courses on Udemy:

• Patreon: https://www.patreon.com/tableaumagic

Also, do be sure to check out our various courses:

• Creating Bespoke Data Visualizations (Udemy)
• Introduction to Tableau (Online Instructor-Led)
• Advanced Calculations (Online Instructor-Led)
• Creating Bespoke Data Visualizations (Online Instructor-Led)