Filling In An Average Line (Line Chart)

[intapiuser]

In some cases, we might want to compare a metric against the average but if the average does not have a result for the entire x-axis (numerator does not have a value for each point in the x-axis but the denominator does), then the average line (Mean and Mean Upper Threshold) will be chopped up as seen below.

Without the script:

The script below will fill out the average line across the entire x-axis as seen below.

With the script:

var series1 = 3;
var series2 = 4;

// Set markers enabled to false for a series
function setMarker(array, enabledFlag) {
for ( var i = 0; i < array.length; i++) {
array[i].marker.enabled = false;
}

}

widget.on('render', function(sender,se){

// edit index of series to select the series you want to turn off markers for
setMarker(sender.queryResult.series[series1].data, false);
setMarker(sender.queryResult.series[series2].data, false);
})

 

widget.on('processresult',function(se,ev){

var s = ev.result.series[series1].data;
fillLine(s);

var s = ev.result.series[series2].data;
fillLine(s);

})


//Functions find the first value and fills the array with this value


function fillLine(s) {


function findValue(v) {
if (v.y) {
return v.y;
}
}

var found = s.find(findValue);

function setAll(a, v) {

var i, n = a.length;
for (i = 0; i < n; ++i) {
a[i].y = v.y;
}
}

setAll(s,found);

}