Introduction
This script will sort the columns of a Columns chart (with break-by) by ascending or descending order.
The Script
Place the following script in the widget's script box
widget.on('processresult',function(se,ev){
var seriesName = 'Years';
var sortOrder = 'DESC'; // 'ASC' or 'DESC'
if (sortOrder === 'ASC') {
ev.result.series.sort(function(b,a){return a.name.localeCompare(b.name)*(-1); });
}
else {
ev.result.series.sort(function(b,a){return a.name.localeCompare(b.name); });
}
var series = ev.result.series;
$.each(series, function(i, v) {
series[i].legendIndex = i;
})
})Example
