RadarChart by ClearPeaks Sorting

Hi Anonymous ,

Custom visuals like the ClearPeaks Radar chart often lack full sorting functionality.

Even when sort fields are added, the visual typically honors only lexicographic string order. That’s why using numeric prefixes with proper padding is the most reliable solution.

Since you're using the CategoryNameIndicator field (e.g., "1 – US Manufacturing ISM"), the chart implicitly sorts alphabetically, not numerically. If the prefixes are inconsistent (such as "1 – ...", "10 – ...", "2 – ...") the sort will break.

So, try this workaround

Step 1: Pad IndicatorSort to Two Digits
Create a new calculated field in QuickSight:

concat( lpad(cast([IndicatorSort] as varchar), 2, '0'), ' – ', [INDICATOR] )

Name this field something like RadarSortCategory. This will ensure the radar chart follows the correct circular order.

Step 2: Use This New Field in the Radar Chart
Drag RadarSortCategory into the Category field well.
Keep Percentile in the Values field.
Do not use IndicatorSort directly, let the prefixed string control the order.

Best Regards,
Chaithra E.