Forum Discussion

kitloong's avatar
kitloong
Cloud Apps
01-22-2022
Solved

How to customize the order of a column chart?

  I am trying to change the order of the columns. I would like the order be from the left: National, My-Group, Firm 2113, etc. Is it possible?   Thanks! Kit
Finance Analytics
  • harikm007's avatar
    harikm007
    01-26-2022

    kitloong ,

    Please try this alternate script to sort items manually

    var categories= ['5','4','3','2','1','0'];

widget.on('queryend',function(se,ev){
	ev.rawResult.values.sort(function(a, b){
		var aIndex = categories.indexOf(a[0].data.trim());
		var bIndex = categories.indexOf(b[0].data.trim());

		if (aIndex < bIndex)
			return -1;
		if (aIndex > bIndex)
			return 1;

		return 0;
	})
})

     (update the array 'categories'  with list of items in order)

    -Hari

kitloong's avatar
kitloong
Cloud Apps
01-26-2022

Hi Andy,

This looks interesting! However, I believe my company uses the Sisense Cloud, and I don't know how to access it. I'll give it a try when I find out how.

Thanks for your solution.