Datasource: Tableau’s Default Sample Superstore
Hint:
- Require one category (in our case, Sub-category) and a measure (Sales).
- Join custom text file (Source: https://github.com/DataScienceRoadMapDSRM/Tableau-Dashboards-info/blob/main/Radial%20Bar%20chart%20values.txt ) with our Datasource, create relevant calculated fields and configure quick table calculations.
Steps to create a viz.
Step 1: Add a Datasource and load downloaded text file from above source into Tableau.
Step 2: Drag a Radial Bar Chart Value table to physical layer of Orders table to create inner join and create Join Calculation to be 1.
Be aware that joining will actually duplicates the data for our values of 0 and 270 as created in above text file. For accurate calculations , consider dividing measure by 2.
Step 3: Now create a bin off ‘Value’ field from text file, you can find it under Orders and name it as Path using below configuration.
Step 4: Create calculated field and name it _Index.
Since, index starts from 1 and we have Values as 0 and 270, that is why we have created such calculated field.
Step 5: Create another calculated field and name it _Sales.
This calculation uses our measure i.e. Sales.
Step 6: Create calculated field again and name it _Rank to rank our dimension as below.
Step 7: Now again create two calculated fields for Cartesian Co-ordinates, X and Y.
Step 8: Now, let’s create some visuals.
- Drag X and Y into Rows and Columns shelf.
- Dimension (Sub-category) into color shelf.
- Path to Detail mark card.
Now, edit table calculation of calculated field X and Y in same order using Specific Dimensions.
- _index mapped to Path
- _Rank mapped to Sub-category
- _Sales mapped to Path
Do the same for Y as well.
The result of that configuration produces such viz where, radial of bars start from 0 to 270 degrees, and length to be adjusted and ranked as per measure values (i.e. SUM of Sales).
Again, we need couple of more calculated fields and re-configure table calculations to achieve final result.
Step 9: Change chart type to Line and drag Path field to Path in Marks card.
Step 10: Duplicate _Sales field and rename it as _Sales_Max.
Step 11: Create another calculated field and rename it as Percentage.
We have same formula _Sales and _Sales_Max, but _Sales will select all values row wise whereas, _Sales_Max select maximum value among Sub-category.
Step 12: Now, edit X and Y by multiplying _index with Percentage.
Edit same to Y as well.
Step 13: Configure table calculation X and Y again, but this time _Sales_Max mapped to Path and Sub-category.
The result would look like below:
With bit of a formatting, such as increasing the size of bars, applying labels, and hiding headers, we can visualize the final result as:
Thats’s our beautiful radial chart.
Recreated using https://www.youtube.com/watch?v=kcdPCq2qxkU&t=304s
Thank You.