Toan Hoang

Radial Fan Charts in Tableau

Toan Hoang

I was looking for inspiration for my second Epic Viz and thus was experimenting with Tableau to see what can be done. In the process, I put together a Radial Fan (or Funnel) Chart to give a high level view of the Sales pipeline. I think this will be the basis of a really cool visualisation, but until my Epic Viz Volume 2 is released, I hope you all enjoy this tutorial.

Note: This is an alternative type of data visualisation, and sometimes pushed for by clients. Please always look at best practices for data visualisations before deploying into production.

Data

Load the following data into Tableau Desktop / Public. 

Channel,Metric,Path,Value
Website,Leads,0,600
Website,Leads,201,600
Website,Qualified,0,300
Website,Qualified,201,300
Website,Proposal,0,180
Website,Proposal,201,180
Website,Sale,0,100
Website,Sale,201,100
Social Media,Leads,0,300
Social Media,Leads,201,300
Social Media,Qualified,0,270
Social Media,Qualified,201,270
Social Media,Proposal,0,200
Social Media,Proposal,201,200
Social Media,Sale,0,150
Social Media,Sale,201,150

Note: we need four records for each Country as we are going to be drawing lines and using densification to get more points on our view. For more information, check out our article on Data Densification.

Calculated Fields

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

Create Path (bin)

Create a parameter called Distance from Center

Index

INDEX()-1

TC_Value

WINDOW_MAX(MAX([Value]))

TC_Max Value

WINDOW_MAX(SUM([Value]))

TC_Percentage

[TC_Value]/[TC_Max Value]*0.75

Note: You can change the 0.75 to increase or decrease the size of the fan.

Rank

RANK_UNIQUE([TC_Value],"asc")

Multiplier

IF [Channel] = "Website" THEN
    1
ELSE
    -1
END

Note: This is hardcoded, but you can make it more dynamic if you want to.

X

IF [Index] <= 100 THEN
    SIN(RADIANS([Index]*[TC_Percentage]))
    *([Rank]+[Distance from Center])
ELSE
    SIN(RADIANS((201-[Index])*[TC_Percentage]))
    *([Rank]+[Distance from Center]+1)
END*WINDOW_MAX(MAX([Multiplier]))

Y

IF [Index] <= 100 THEN
    COS(RADIANS([Index]*[TC_Percentage]))
    *([Rank]+[Distance from Center])
ELSE
    COS(RADIANS((201-[Index])*[TC_Percentage]))
    *([Rank]+[Distance from Center]+1)
END

So now that we have created a lot of Calculated fields, we will now put this together into a Worksheet.

Worksheet

We will now build our worksheet:

If all goes well, you should see something like the following:

yep, we are not quite there yet, but I do love my interesting shapes in Tableau. We are now going to adjust the Table Calculation settings for X and Y to get the visualisation we desire.

You should now see the following visualisation, and we are almost done.

I now want us to work on the cosmetics of this data visualisation.

You should now have the following:

Now we will create the background worksheet to give us our completed guidelines.

If all goes well you should now have the following:

Now it is all about assembling our dashboard.

and boom, you should have the following:

You can see my completed worksheet on my Tableau Public profile at:
https://public.tableau.com/profile/toan.hoang#!/vizhome/RadialFanChart/RadialFanCharts

Extra Credit: Change the multiplier in the TC_Percentage Calculated Field to see the results.

Summary

I hope you all enjoyed this article as much as I enjoyed writing it and as always do share 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:

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

Exit mobile version