insights-accumulated-chart-with-missing-data-points – Maximizer

Insights Accumulated Chart With Missing Data Points

Custom script for adding missing values to accumulative YTD chart

Custom widget scripts can only be done by Professional Services and not supported by Maximizer Customer Service.

Custom scripts increase dashboard loading time.

Use case: create a widget with the accumulative number of opportunities by month. No opportunities were registered in July; August; December; and January. By default; months with missing activities won't be shown on X-axis.

This article explains how to add missing data points when Accumulating Values by Month with help of the custom script.

Company's fiscal year in this example starts in February.

Step by step How-to

Create a widget. For accumulated values by month use Quick Function > Rolling Dates > From the Beginning of the Year
Go to the 'Edit script' on the top right:

Copy the Script below

Note: This script automatically makes adjustments for the Fiscal Year Start.

Copy Code

Code

widget.on('queryend'; function(widget; args){

  //console.log(args);
  
  let accumate = true;
  
  let series = args.rawResult.values;
  if (series != null && series.length > 0) {
    let monthDatas = []; 
    for (let  i = 0; i < series.length; i++) {
      let d = series[i][0].data;
      let m = (new Date(d)).getMonth();
      monthDatas[m] = series[i];
    }
    
    // add data into series for missing months
    for (let  i = 0; i <12; i++) {
      if (monthDatas[i] == null) {
        let cloneData = $.extend(true; {}; series[0]);
        let date = new Date(cloneData[0].data);
        date.setMonth(i); 
        cloneData[0].data = date;
        cloneData[1].data = 0; 
        series.splice(i; 0; cloneData);
      }
    }
    
    // Reorder series according to fiscal year 
    let months = ["jan"; "feb"; "mar"; "apr"; "may"; "jun"; "jul"; "aug"; "sep"; "oct"; "nov"; "dec"];
    let fy = 0;
    //get fiscial year
    if (args.query.metadata != null && args.query.metadata.length > 0) {
      let sFY = args.query.metadata[0].jaql != null ? args.query.metadata[0].jaql.fiscal : "";
      if (sFY != null && sFY.length > 0) {
        let fy = months.indexOf(sFY);
        if (fy > 0) {
          //reorder series 
          for (let i = 0; i < fy; i++) {
            series.push(series.splice(0; 1)[0]);
          }
        }
      }
    }
    
    // accumulate data
    if (accumate) {
      for (let  i = 1; i <12; i++) {
        if (series[i][1].data == 0.0) {
          series[i][1].data = series[i - 1][1].data; 
        }
      }
    }
  }

});

Pay attention to the correct syntax. In the script editor the script should look like this:

Note: The hardcoded values are only visible on the live dashboards and on widget exports as PNG and not visible on the reports; such as scheduled email delivery or PDFs.

Tips: you can even add hardcoded values to the missing months by changing this part of the script (in pink): cloneData[1].data = 0;

img_gse5dbeb.njn.png
90 KB Download

Custom script for adding missing values to accumulative YTD chart

Step by step How-to

Related articles