Column Chart - Reorder X-Axis

When creating a column chart you'd sometimes want to reorder the category fields

Apply the following widget script:

widget.on('processresult', function(widget,result) {
  // Wanted Order
  let order = ['New','Used','Refurbished','Unspecified']

  // For each series
  result.result.series.forEach(function(series) {
    let newData = new Array(series.data.length);
    for (let i = 0 ; i < series.data.length ; i++) {
      let categoryName = series.data[i].selectionData[0] 
      let shouldBeAt = order.indexOf(categoryName)
      newData[shouldBeAt] = series.data[i]
    }
    series.data = newData
  })

  // Replace X-Axis Labels
  result.result.xAxis.categories = order
})

Before	After