Setting time window to data on time chart

Dashboard Designer
1

Hi,

i have problem with reduction of data amount on chart. My goal is to have always data from last 8 hours [time taken from created column on sp]. List is already limited to last 48h. Problematic is a fact, that i always need last 8h, regardless of day beginning date.
On X axis i need always only last 8h of data.

image
image1221×436 8.82 KB

1 Like
2

Dear @jacek,
Hmm, you could try something like this in Dashboard > Advanced code to filter out all the items with time difference over 8 hours:

var handlers = {};
handlers.preRender = function(config, logger) {
  for(var i = 0; i < config.series.length; i++){
    var series = config.series[i];
    var new_data = series.data.filter(function(item){ 
      var time_diff = Math.abs(new Date() - item.Created);
      return time_diff < 28800000;
    });
    series.data = new_data;
  }
  logger.debug('Configuration: ', config);
  return true;
}
1 Like
3

Thanks. Works like a charm!

4

Hi,

Exacly what i meant. Thank You !!!!