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.