Absolute Values In Column Charts

[intapiuser]

Introduction

Using the following script we can set column chart values to their absolute values

Before:

After:

Script

Place the following script in the column charts script:

widget.on('processresult', function(w,e) {

 var s = e.result.series[0].data;

 
 for (var i = 0 ; i < s.length ; i++) {


  if(s[i].y<0){
   s[i].y = s[i].y*-1;
  }
  else{
   s[i].y = s[i].y;
  }
  
 }
  
});

For cases when more than one value is plotted, one can apply the following script for both measures:

Before:

After:

Script for two measures:

widget.on('processresult', function(w,e) {

 var s = e.result.series[0].data;
 var t = e.result.series[1].data;
 
 for (var i = 0 ; i < s.length ; i++) {
  debugger

  if(s[i].y<0){
   s[i].y = s[i].y*-1;
  }
  else{
   s[i].y = s[i].y;
  }
  
 }
  for (var j = 0 ; j < t.length ; j++) {
  debugger

  if(t[j].y<0){
   t[j].y = t[j].y*-1;
  }
  else{
   t[j].y = t[j].y;
  }
  
 }
});

Here's for instances where you have more than 1 or 2 series/measures.

widget.on('processresult', function(w,e) {
var leng = e.result.series.length;
for (var k = 0; k < leng; k++) {
var s = e.result.series[k].data;
for (var i = 0 ; i < s.length ; i++) {
debugger
if(s[i].y<0){
s[i].y = s[i].y*-1;
}
else{
s[i].y = s[i].y;
}
}
}});