Last Modified Date: 20 Jul 2023
Environment
- Tableau Desktop
Answer
Option 1In Tableau Desktop, add a background image to the view, and then add X and Y coordinates to the data source to plot data over the background image. For more information, see Radar Charts in Tableau – part 1 in the Information Lab blog.
Option 2
The attached workbook RadarChart.twbx is created from the attached excel file SampleData.xlsx to demonstrate the following steps.
- Open SampleData.xlsx and add rows that KPI Name is KPI8 for each member. The KPI Value of KPI8 should be the same as that of KPI1 for each member.
In the Edited_SampleData sheet of SampleData.xlsx, the rows added in this step are colored by green. - Add rows that Member is MAX for the same number of members included in the data source. The KPI Value of MAX should be the maximum value of the rader chart.
In the Edited_SampleData sheet of SampleData.xlsx, the rows added in this step are colored by yellow. - Open the edited data source by Tableau Desktop.
- Click Analysis > Create Calculated Field, name the new calculated field as 1.INDEX with the following formula.
INDEX()
- Create a calculated a new field named as 2.KPI Counts with the following formula.
{FIXED:COUNTD([KPI Name])}-1
- Create a calculated a new field named as 3.Radians with the following formula.
PI()/2 - 2*PI()/avg([2.KPI Counts])*([1.INDEX]-1)
- Create a calculated a new field named as 4.X Coordinate with the following formula.
SUM([KPI Value])*COS([3.Radians])
- Create a calculated a new field named as 5.Y Coordinate with the following formula.
SUM([KPI Value])*SIN([3.Radians])
- Create a calculated a new field named as 6.Labels with the following formula.
IF [KPI Name]="KPI8" THEN NULL ELSE [KPI Value] END
- On the marks card, select Line and place Member to color, KPI Name to path, 2.KPI Counts to details and KPI Values to labels.
- Place 4.X Coordinate to columns and 5.Y Coordinate to rows.
- Right-click 4.X Coordinate in columns > Edit Table Calculation.
- Select Specific Dimensions and arrange dimensions in the order of Member, KPI Names from the top, then check both dimensions. Select Member for the Restarting every setting.
- Right-click 5.Y Coordinate in rows > Edit Table Calculation.
- Select Specific Dimensions and arrange dimensions in the order of Member, KPI Names from the top, then check both dimensions.
- (Option) Add Members to filters.
Additional Information
- The Information Lab: Radar Charts in Tableau – part 2
- The Information Lab: Radar Charts in Tableau – Part 3
- To voice your support for the inclusion of this feature in a future product release, add your vote to the following Community Idea: New Chart types: Radar/Spider, Perceptual, Tornado.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials