NS: Chart 011 (Engagement Trend)

chart011.js

function getData() {
    var recordType = "customrecord_sc_request";
    var searchId = "customsearch_rcm_dealtracker_timeline";
    var results = nlapiSearchRecord(recordType, searchId);

    var _data = null;
    var categories = [];
    
    if (!results || results.length === 0) { return None; }

    data_all = [];
    data_0 = [];
    data_1 = [];
    data_2 = [];
    data_3 = [];
    
    var len = results.length;
    var i   = 0;
    for (i; i < len; i++) {
        var cols        = results[i].getAllColumns();
        var id          = results[i].getValue(cols[0]);
        var name        = results[i].getText(cols[0]);
        var this_month  = results[i].getValue(cols[2]);
        var last_month  = results[i].getValue(cols[3]);
        var two_month   = results[i].getValue(cols[4]);
        var three_month = results[i].getValue(cols[5]);

        categories.push(name);

        data_0.push(this_month);
        data_1.push(last_month);
        data_2.push(two_month);
        data_3.push(three_month);
    }

    data_all.push(data_0);
    data_all.push(data_1);
    data_all.push(data_2);
    data_all.push(data_3);

    _data = {'data_all': data_all, 'categories': categories};
    return _data;
}

var callback4 = function() {
    var data = getData() || null;
    if (!data || data === null) { return; }

    var dataLabels = ["This Month", "Last Month", "2 Months Ago", "3 Months Ago"];

    var options = {
        series: [
            {
                name: dataLabels[0],
                data: data.data_all[0]
            }, {
                name: dataLabels[1],
                data: data.data_all[1]
            }, {
                name: dataLabels[2],
                data: data.data_all[2]
            }, {
                name: dataLabels[3],
                data: data.data_all[3]
            }
        ],
        chart: {
            height: 420,
            type: 'bar',
        },
        colors: ["#3498db", "#7f8c8d", "#95a5a6", "#bdc3c7"],
        dataLabels: {
            enabled: false
        },
        stroke: {
            show: true,
            width: 2,
            colors: ['transparent']
        },
        xaxis: {
          categories: data.categories
        },
        yaxis: {
            title: {
                text: '# of Requests'
            },
            min: 0,
            max: 10,
            tickAmount: 10
        },
        fill: {
            opacity: 1
        },
        legend: {
            position: 'top'
        },
        tooltip: {
            y: {
                formatter: function (val) {
                    return val
                }
            }
        },
        title: {
            align: 'center',
            text: 'SC Engagement Trend (Trailing 3 Months)'
        }
    };

    var chart = new ApexCharts(document.querySelector("#chart011"), options);
    chart.render();
};

if (document.readyState === "complete" || (document.readyState !== "loading" && !document.documentElement.doScroll)) {
    callback4();
} else {
    document.addEventListener("DOMContentLoaded", callback4);
}

chart011.min.js

function getData(){var a=nlapiSearchRecord("customrecord_sc_request","customsearch_rcm_dealtracker_timeline"),t=[];if(!a||0===a.length)return None;data_all=[],data_0=[],data_1=[],data_2=[],data_3=[];for(var e=a.length,l=0;l<e;l++){var d=a[l].getAllColumns(),n=(a[l].getValue(d[0]),a[l].getText(d[0])),o=a[l].getValue(d[2]),r=a[l].getValue(d[3]),c=a[l].getValue(d[4]),s=a[l].getValue(d[5]);t.push(n),data_0.push(o),data_1.push(r),data_2.push(c),data_3.push(s)}return data_all.push(data_0),data_all.push(data_1),data_all.push(data_2),data_all.push(data_3),{data_all:data_all,categories:t}}var callback4=function(){var a=getData()||null;if(a&&null!==a){var t=["This Month","Last Month","2 Months Ago","3 Months Ago"],e={series:[{name:t[0],data:a.data_all[0]},{name:t[1],data:a.data_all[1]},{name:t[2],data:a.data_all[2]},{name:t[3],data:a.data_all[3]}],chart:{height:420,type:"bar"},colors:["#3498db","#7f8c8d","#95a5a6","#bdc3c7"],dataLabels:{enabled:!1},stroke:{show:!0,width:2,colors:["transparent"]},xaxis:{categories:a.categories},yaxis:{title:{text:"# of Requests"},min:0,max:10,tickAmount:10},fill:{opacity:1},legend:{position:"top"},tooltip:{y:{formatter:function(a){return a}}},title:{align:"center",text:"SC Engagement Trend (Trailing 3 Months)"}};new ApexCharts(document.querySelector("#chart011"),e).render()}};"complete"===document.readyState||"loading"!==document.readyState&&!document.documentElement.doScroll?callback4():document.addEventListener("DOMContentLoaded",callback4);

chart011.sql

'<script src="https://cdn.jsdelivr.net/npm/apexcharts"></script><script>function getData(){var a=nlapiSearchRecord("customrecord_sc_request","customsearch_rcm_dealtracker_timeline"),t=[];if(!a||0===a.length)return None;data_all=[],data_0=[],data_1=[],data_2=[],data_3=[];for(var e=a.length,l=0;l<e;l++){var d=a[l].getAllColumns(),n=(a[l].getValue(d[0]),a[l].getText(d[0])),o=a[l].getValue(d[2]),r=a[l].getValue(d[3]),c=a[l].getValue(d[4]),s=a[l].getValue(d[5]);t.push(n),data_0.push(o),data_1.push(r),data_2.push(c),data_3.push(s)}return data_all.push(data_0),data_all.push(data_1),data_all.push(data_2),data_all.push(data_3),{data_all:data_all,categories:t}}var callback4=function(){var a=getData()||null;if(a&&null!==a){var t=["This Month","Last Month","2 Months Ago","3 Months Ago"],e={series:[{name:t[0],data:a.data_all[0]},{name:t[1],data:a.data_all[1]},{name:t[2],data:a.data_all[2]},{name:t[3],data:a.data_all[3]}],chart:{height:420,type:"bar"},colors:["#3498db","#7f8c8d","#95a5a6","#bdc3c7"],dataLabels:{enabled:!1},stroke:{show:!0,width:2,colors:["transparent"]},xaxis:{categories:a.categories},yaxis:{title:{text:"# of Requests"},min:0,max:10,tickAmount:10},fill:{opacity:1},legend:{position:"top"},tooltip:{y:{formatter:function(a){return a}}},title:{align:"center",text:"SC Engagement Trend (Trailing 3 Months)"}};new ApexCharts(document.querySelector("#chart011"),e).render()}};"complete"===document.readyState||"loading"!==document.readyState&&!document.documentElement.doScroll?callback4():document.addEventListener("DOMContentLoaded",callback4);</script><div style="height:450px"><div id="chart011"></div></div>'