Reverse X-axis order in a Line Chart

Follow

Tommy

July 27, 2016 17:52

Introduction

By default, Sisense sorts a line chart in ascending order. The only other way to order the line chart is by the values in the series being plotted. The code in this article will enable you to reverse the chart order.

 

Implementation

The code for this functionality is attached to the post and embedded in this article. You'll implement the code as a widget script. There's more information on adding widget scripts here: https://www.sisense.com/documentation/extending-dashboard-functionality-javascript/

Paste the following code into your widget's script editor:

widget.on("processresult",function(w,args){
	for (i=0;i<args.result.series.length;i++) {
		args.result.series[i].data.reverse();
	};
	args.result.xAxis.categories.reverse();
})

 

 

 

reverse_line_chart.js

0

• 

  David Hertzberg October 27, 2016 16:12

  Thanks a lot Tommy !

  Where can we find a complete API reference ? The developperwebsite makes no reference to the reverse() method, and there is no DOM description for widgets and dashboards. You have to guess from examples or DOM explorer in your browser ...

  Thanks,

  David.

  0

  Comment actions Permalink
• 

  Sam Ovenshine June 28, 2017 19:48

   

  To reverse the y-axis, try this script:

  widget.on("processresult",function(w,args){
  for (i=0;i<args.result.series.length;i++) {
  args.result.series[i].data.reverse();
  };
  args.result.yAxis[0].categories.reverse();
  })

  0

  Comment actions Permalink
• 

  Glenys Salas August 29, 2017 21:05

  Hi!  I tried this and it didn't work

   

  
  
  

  0

  Comment actions Permalink
• 

  Sam Ovenshine September 07, 2017 18:03

  Hi Glenys,

  Thanks for letting us know. We'll take a look and see if we can update the script.

  Sam

  0

  Comment actions Permalink
• 

  Brian Wilson October 04, 2017 20:29

  Hi Sam, Any update on this one? I'd like to flip a line chart widget so that 1 (Ranked First) is at the top of Y-axis and the bottom ranked item is at the bottom. The chart would look like the attached (though with positive numbers instead of negative ones!)

  

  0

  Comment actions Permalink
• 

  Anjali Yadav January 08, 2019 22:15

  I need a script to switch the ordering of x-axis in a chart with no break-by. Please help.

  0

  Comment actions Permalink
• 

  Tad Carlson January 30, 2019 17:09

  I had success with the original script to reverse order of the x-axis:

  widget.on("processresult",function(w,args){
  	for (i=0;i<args.result.series.length;i++) {
  		args.result.series[i].data.reverse();
  	};
  	args.result.xAxis.categories.reverse();
  })

   

  However, I'm wondering if anything was ever developed for the same functionality y-axis?  

  0

  Comment actions Permalink
• 

  An Y January 30, 2019 17:28

  Hi Tad 

  What is your chart type Bar or Column ?  My results with your script -

  Bar chart : reversed the y-axis

  Coln chart : reversed  nothing

   

  An

  0

  Comment actions Permalink
• 

  Tad Carlson January 30, 2019 17:30

  Line chart

  0

  Comment actions Permalink
• 

  An Y January 30, 2019 17:42 (Edited January 30, 2019 18:02)

  Correction : worked on my Line chart x axis as you had earlier stated.

  For the Y-axis I just tried the element highlighted in the screenshot attached, shows the array reversed in the console but no change on the  display,

  0

  Comment actions Permalink

Please sign in to leave a comment.