Radar Chart Highchart

Q&A
, , ,
1

Here is my Highchart code

{
  "chart": {
    "polar": true,
    "type": "line"
  },
  "title": {
    "text": "Carrier Performance Comparison (RootMetrics)"
  },
  "pane": {
    "size": "80%"
  },
  "xAxis": {
    "categories": ["Accessibility", 
    "Data",
    "Responsiveness",
    "Reliability", 
    "Text",
    "Speed",
    "Video",
    "Call",
    "Overall"
       ],
    "tickmarkPlacement": "on",
    "lineWidth": 0
  },
  "yAxis": {
    "gridLineInterpolation": "polygon",
    "lineWidth": 0,
    "min": 1,
    "max": 4,
    "reversed": true
  },
 
  "tooltip": {
    "shared": true,
    "pointFormat": "<span style='color:{series.color}'>{series.name}: <b>{point.y}</b><br/>"
  },
  "legend": {
    "align": "right",
    "verticalAlign": "middle",
    "layout": "vertical"
  },
  "series": [
  
    {
      "name": "AT&T",
      "data": ["unique",["getColumn", ["filter", ["getColumn", 0], ["==", ["item", 0], "AT&T"]], 2]],
      "pointPlacement": "on"
    },
    
    {
      "name": "T-Mobile",
      "data":["unique", ["getColumn", ["filter", ["getColumn", 0], ["==", ["item", 0], "T-Mobile"]], 3]],
      "pointPlacement": "on"
    },
    
    {
      "name": "Verizon",
      "data": ["unique",["getColumn", ["filter", ["getColumn", 0], ["==", ["item", 0], "Verizon"]], 4]],
      "pointPlacement": "on"
    }

  
  ],
  "responsive": {
    "rules": [
      {
        "condition": {
          "maxWidth": 500
        },
        "chartOptions": {
          "legend": {
            "align": "center",
            "verticalAlign": "bottom",
            "layout": "horizontal"
          },
          "pane": {
            "size": "70%"
          }
        }
      }
    ]
  }
  
}

where i Groupby i have - carrier , rootscoreindex as col0, col1 ,
also in values i have -3 calculated fields, (ATT, Tmobile and verizon) with aggregating to avg

where the formula for each is
ATT ifelse(carrier=‘AT&T’, {Rank_Carrierwise}, null)

and where {Rank_Carrierwise} is
ifelse(carrier = ‘AT&T’, {collection_rootscore_rank},
ifelse(carrier=“T-Mobile”, {collection_rootscore_rank},
ifelse(carrier=“Verizon”, {collection_rootscore_rank},NULL)))

i am getting below chart where last 3 values / corners are missing Video , call & Overall, is there any solution for this

image
image741×598 32.7 KB

2

Hi @PreetiV , without having access to your data there could be a number of reasons for this such as:

  1. Missing data: Verify that the fields you’re using for the visual contains data for all carriers (AT&T, T-Mobile, Verizon) across all categories
  2. Calculated fields: Verify the results of your calculated field return the values as expected. Your {Rank_Carrierwise} formula might benefit from some simplification as this looks like it may be returning the same {collection_rootscore_rank} value regardless of which carrier is being evaluated
  3. Consider setting the connectNulls parameter here to True or False depending on your needs. You can learn more about this here.

We hope this solution works for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution" (check box under the reply).