How to create 'Highchart Dependency Wheel' on quicksight?

[Saarben]

Hi, Trying to create an Highchart ‘Dependency Wheel’.
With the syntax below i was able to create it. But when trying to replace the manual data with my fields there is no luck. i even created calculated fields (with the right format) with the names of “from”,“to” and “weight” but it still not working.
I know there is data and the fields types and placement are correct:

{
“chart”: {
“type”: “dependencywheel”
},
“title”: {
“text”: “Highcharts Dependency Wheel”
},
“series”: [
{
“name”: “Dependency wheel series”,
“keys”: [“from”, “to”, “weight”],
“data”: [
[“Brazil”, “Portugal”, 5],
[“Brazil”, “France”, 1],
[“Brazil”, “Spain”, 1],
[“Brazil”, “England”, 1],
[“Canada”, “Portugal”, 1],
[“Canada”, “France”, 5],
[“Canada”, “England”, 1],
[“Mexico”, “Portugal”, 1],
[“Mexico”, “France”, 1],
[“Mexico”, “Spain”, 5],
[“Mexico”, “England”, 1],
[“USA”, “Portugal”, 1],
[“USA”, “France”, 1],
[“USA”, “Spain”, 1],
[“USA”, “England”, 5],
[“Portugal”, “Angola”, 2],
[“Portugal”, “Senegal”, 1],
[“Portugal”, “Morocco”, 1],
[“Portugal”, “South Africa”, 3],
[“France”, “Angola”, 1],
[“France”, “Senegal”, 3],
[“France”, “Mali”, 3],
[“France”, “Morocco”, 3],
[“France”, “South Africa”, 1],
[“Spain”, “Senegal”, 1],
[“Spain”, “Morocco”, 3],
[“Spain”, “South Africa”, 1],
[“England”, “Angola”, 1],
[“England”, “Senegal”, 1],
[“England”, “Morocco”, 2],
[“England”, “South Africa”, 7],
[“South Africa”, “China”, 5],
[“South Africa”, “India”, 1],
[“South Africa”, “Japan”, 3],
[“Angola”, “China”, 5],
[“Angola”, “India”, 1],
[“Angola”, “Japan”, 3],
[“Senegal”, “China”, 5],
[“Senegal”, “India”, 1],
[“Senegal”, “Japan”, 3],
[“Mali”, “China”, 5],
[“Mali”, “India”, 1],
[“Mali”, “Japan”, 3],
[“Morocco”, “China”, 5],
[“Morocco”, “India”, 1],
[“Morocco”, “Japan”, 3],
[“Japan”, “Brazil”, 1]
],
“dataLabels”: {
“color”: “#333”,
“style”: {
“textOutline”: “none”
},
“textPath”: {
“enabled”: true
},
“distance”: 10
},
“size”: “95%”
}
]
}

[Xclipse]

Hi @Saarben

Here is the Highchart “Dependency Wheel” JSON code. Please try the following code.

Example:

{
  "chart": {
    "type": "dependencywheel"
  },
  "title": {
    "text": "Highcharts Dependency Wheel"
  },
  "series": [
    {
      "type": "dependencywheel",
      "name": "Dependency wheel series",
      "keys": ["from", "to", "weight"],
      "data": ["map",

        ["getColumn",0,1,2], //from, to, weight

        {

          "from":["get",["item"],0], //from

          "to":["get",["item"],1], //to

          "weight":["get",["item"],2]  //weight

        }  

      ], 
      "dataLabels": {
        "color": "#333",
        "style": {
          "textOutline": "none"
        },
        "textPath": {
          "enabled": true
        },
        "distance": 10
      },
      "size": "95%"
    }
  ]
}

[Saarben]

@Xclipse that’s great thanks and it’s working when i have 2 dimensions.
Wonder if you can think how to adjust now to my case.
Actually my ‘from’ and ‘to’ are a concat of different fields changed by parameter.
It called “Dynamic connection3” and hold the following syntax below.
How can i adjust the high chart to receive only 1 dimension that is a concat of the ‘from’ and ‘to’?

“Dynamic connection3”:
ifelse(${Breakdown3}=‘Country’,concat({COUNTRY_NAME},‘-’,{SUPPLY_COUNTRY_NAME}) ,
${Breakdown3}=‘Business unit’,concat({BUSINESS_UNIT_NAME},‘-’,{SUPPLY_BUSINESS_UNIT_NAME}),
${Breakdown3}=‘Function’,concat({FUNCTION_NAME},‘-’,{SUPPLY_FUNCTION_NAME}),
${Breakdown3}=‘Sub function’,concat({SUB_FUNCTION_NAME},‘-’,{SUPPLY_SUB_FUNCTION_NAME}),
${Breakdown3}=‘Department 1’,concat({CORPORATE_DEPARTMENT_NAME_ONE},‘-’,{SUPPLY_CORPORATE_DEPARTMENT_NAME_ONE}),
${Breakdown3}=‘Department 2’,concat({CORPORATE_DEPARTMENT_NAME_TWO},‘-’,
{SUPPLY_CORPORATE_DEPARTMENT_NAME_TWO}),
${Breakdown3}=‘Department 3’,concat({CORPORATE_DEPARTMENT_NAME_THREE},‘-’,
{SUPPLY_CORPORATE_DEPARTMENT_NAME_THREE}),
${Breakdown3}=‘Department 4’,concat({CORPORATE_DEPARTMENT_NAME_FOUR},‘-’,
{SUPPLY_CORPORATE_DEPARTMENT_NAME_FOUR}),
${Breakdown3}=‘Department 5’,concat({CORPORATE_DEPARTMENT_NAME_FIVE},‘-’,
{SUPPLY_CORPORATE_DEPARTMENT_NAME_FIVE}),
‘’)

[Xclipse]

Hi @Saarben

In Highcharts Dependency Wheel, each data point represents a connection between two nodes and requires at three values per entry.

• From (Source node) – The starting node of the connection.
• To (Target node) – The destination node of the connection.
• Weight – The numerical value that determines the thickness of the link.

If you pass only concatenation “from_to” and “weight”, it will not work because the chart needs a target node to establish a connection.

To separate the “Dynamic connection3” calculation into distinct “from” and “to” fields for use in a Highcharts dependency wheel, you need to extract each component separately.

Example: (Syntax may vary - Modify the calculation with your requirement)

From

ifelse(
  ${Breakdown3}='Country', {COUNTRY_NAME},
  ${Breakdown3}='Business unit', {BUSINESS_UNIT_NAME},
  ${Breakdown3}='Function', {FUNCTION_NAME},
  ${Breakdown3}='Sub function', {SUB_FUNCTION_NAME},
  ${Breakdown3}='Department 1', {CORPORATE_DEPARTMENT_NAME_ONE},
  ${Breakdown3}='Department 2', {CORPORATE_DEPARTMENT_NAME_TWO},
  ${Breakdown3}='Department 3', {CORPORATE_DEPARTMENT_NAME_THREE},
  ${Breakdown3}='Department 4', {CORPORATE_DEPARTMENT_NAME_FOUR},
  ${Breakdown3}='Department 5', {CORPORATE_DEPARTMENT_NAME_FIVE},
  ''
)

To

ifelse(
  ${Breakdown3}='Country', {SUPPLY_COUNTRY_NAME},
  ${Breakdown3}='Business unit', {SUPPLY_BUSINESS_UNIT_NAME},
  ${Breakdown3}='Function', {SUPPLY_FUNCTION_NAME},
  ${Breakdown3}='Sub function', {SUPPLY_SUB_FUNCTION_NAME},
  ${Breakdown3}='Department 1', {SUPPLY_CORPORATE_DEPARTMENT_NAME_ONE},
  ${Breakdown3}='Department 2', {SUPPLY_CORPORATE_DEPARTMENT_NAME_TWO},
  ${Breakdown3}='Department 3', {SUPPLY_CORPORATE_DEPARTMENT_NAME_THREE},
  ${Breakdown3}='Department 4', {SUPPLY_CORPORATE_DEPARTMENT_NAME_FOUR},
  ${Breakdown3}='Department 5', {SUPPLY_CORPORATE_DEPARTMENT_NAME_FIVE},
  ''
)

[Saarben]

@Xclipse - working thank you .