Sorting Bar Column With Break By Incl. Legened

[intapiuser]

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