How to create a radar chart in Quick Sight (Highcharts) with multiple cities and colored polygons?

Q&A
, , ,
1

Hi QuickSight Community,

I am trying to create a radar chart (polygon chart) in QuickSight using the following dataset structure:

Column Description
col0 Cities (e.g., Pune, Mumbai, Delhi)
col1 Features (e.g., Sales, Marketing, Finance)
col2 Values / Scores (numeric)

What I want:

  1. Radar chart with features (col1) as the polygon corners.

  2. Three separate lines/polygons, each representing a city (col0), with different colors.

  3. Show the values (scores) on the polygon corners.

What I have tried:

  • I tried using HighCharts JSON, but I am not able to properly map col1 as corners and col0 as series, or display multiple polygons with different colors.

  • I also want to ensure that the scores are visible at each point on the radar chart.

Questions:

  • How can I structure the dataset or use calculated fields to achieve this radar chart in QuickSight?

  • How can i get the scores visible at each point on the radar chart.

  • How can I assign different colors to each city polygon?

Any guidance, example, or workaround would be highly appreciated!

Thanks in advance!

2

Hi @PreetiV

QuickSight has a native radar chart that is very easy to use. However, the Highcharts visual can be handy if you want to create a custom radar chart with an inverted axis. Refer to section 17 in the Samples tab.

3

Hi @PreetiV,

Hope everything is well! Were you able to see Xclipse’s suggestion and/or find the solution yourself in the meantime? If we do not hear back within the next 3 business days, I’ll go ahead and close/archive this topic.

Thank you!

4

Hi @PreetiV,

Since we have not heard back, I’ll go ahead and close this topic. However, if you have any additional questions, please feel free to post again in the community and link this thread for any relevant information.

Thank you!