×

Please give details of the problem

Docs

Find

    Developer Guide

        1. Todo Validation
      2. Release Your User Login
      1. Process Reporting API
        1. CSS Examples
        2. CSS Personalization
      2. Performance
        1. List Reinitialization
        2. Holidays
        3. Number Currency Format
        4. Label Modification
        5. Array From WS
        6. Launch Process JQuery
        7. Column Inactivation
        8. Date
        9. Print JSONObject
        10. ArrayJSON to JSONArray
        11. Invalid Fields
        12. Round
        13. Initialization Widget Date
        14. JQuery
        15. Inject JSONObject
        16. Google Tables
        1. Summing Array
        2. API Listener
        3. User Lane Picker
        4. Retrieving Variables Values
          1. Chart Dashboard
          2. Report Chart
          3. Google Visualization
          4. Chart Dashboard Collection
        6. Tags
        7. Collection
        8. File Preview
        9. Dynamic List
        10. Dialog Window
        11. JavaScript Report
        12. Autocomplete Widget
          1. homepage.js
          2. homepage.css
        2. Logout
        3. Custom Login Page
        4. Header
        5. Mobile Devices
        6. Basket
        7. Redirection ExecutionMode
        8. Menu Bar
        9. Information Tags
      1. Composite API Example
      1. Markdown Template
        1. Task Reminder Email
        2. SubProcess
        3. PDF
        4. JavaScript Inclusion
        5. Variable Mapping
        6. Backloop
      3. Trigger
        1. File Visibility
        2. Number Currency Format
        3. Error Handling
        4. JSONObject Concatenation
        5. Loop
        6. Dynamic Variable
        7. List 1000+ Objects
        8. Metadata
        9. Freemarker Container Test
        10. JSONObject Keys Values
        11. List Hash Sequence
        12. Special Freemarker Characters
        13. Salesforce Computation
        14. Array To List
        15. JSONArray Conversion
        16. Lock
        17. JSONObject Creation
        18. Number Test
      1. Customer Management
        1. Messages
        2. Scheduled Process
        1. Custom Lists
          1. Web Interface Stylesheet Tab
          2. Web Interface Analytics Tab
          3. Web Interface Implementation Tab
          4. Web Interface Collection Tab
          5. Web Interface API Tab
          6. Web Interface Design Tab
          7. Web Interface JS Tab
            1. Report Widget
            2. List Widget
            3. JavaScript Widget
            4. History Widget
            5. RadioButton Widget
            6. FileUpload Widget
            7. StaticText Widget
            8. HTML Editor Widget
            9. ProgressBar Widget
            10. Section Widget
            11. Spinner Widget
            12. Image Widget
            13. Multi Checkbox Widget
            14. Tab Widget
            15. Tree Widget
            16. HTML Widget
            17. Checkbox Widget
            18. Button Widget
            19. Custom Widget
            20. URLInput Widget
            21. TextInput Widget
            22. Array Widget
            23. Captcha Widget
            24. Geolocation Widget
          1. Version
          2. Project Version Tab
          3. Project Definition Tab
          4. Project Description Tab
          5. Project Rights Tab
          6. Project Versioned Files Tab
          7. Project Collection Tab
          8. Project Files Tab
        4. Collections
          1. Providers
          2. Processes
          3. Connectors
        6. Revision
          1. Composite API Configuration Tab
          2. Composite API Design Tab
          1. Process Input Tab
          2. Process General Tab
          3. Process Measures Tab
          4. Process Variables Tab
            1. Gate
            2. Process Step Output Variables
              1. Process Task Functional Tab
              2. Process Task Connector Tab
              3. Process Task Script Tab
              4. Process Task Loop Tab
              5. Process Task SubProcess Tab
              6. Process Task Manual Tab
              7. Process Task Email Tab
            4. Process Step Input Variables
            5. Process Step Testing Variables
              1. Process Intermediary Event
              2. Process Start Event
              3. Process Timer Event
          6. Process Design
          1. Organization
          2. Roles entities
        1. My Applications
        2. Files
        3. Home
        1. Process Examples
        2. Connectors
        1. Web Interface Reports
          1. Parameters
          2. Runtime Users
          3. Execution Path
          4. Measuring
        1. Configuration
        2. Users
        3. Usage
      1. Mobile
      2. Offline
      1. Collections BackOffice
      2. Collections To List
      3. Collections To Array
      4. Collection JS Freemarker
      1. Access Rights
      2. Delegation
      3. Compound Organization Hierarchy
      4. Dynamic Lanes
      5. Scripted Lanes
      6. Runtime Lanes

    Create a dashboard based on a collection

    Introduction

    Dashboards let you get a high level summary information about data. This tutorial will show how to create pie and column charts based on data stored within a RunMyProcess collection.

    Table of Contents


    Practice

    To configure a RunMyProcess dashboard with pie and column charts, we will use Google Visualisation for chart rendering, and a collection as source of data.

    We will need this two predefined Javascript functions :

    The drawPieChart function allows to draw a pie chart:

     1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
    //Display a PieChart
function drawPieChart(html_id, array_data, array_column, chart_title, chart_width, chart_height) {
    // Create our data table.
    var data = new google.visualization.DataTable();
    for (i = 0; i < array_column.length; i++) {
        data.addColumn(array_column[i].type, array_column[i].title);
    }
    var array_array_data = new Array();
    for (i = 0; i < array_data.length; i++) {
        array_array_data.push([array_data[i].label, array_data[i].value]);
    }
    data.addRows(array_array_data);
    // Instantiate and draw our chart, passing in some options.
    var chart = new google.visualization.PieChart(document.getElementById(html_id));
    chart.draw(data, {
    width : chart_width,
    height : chart_height,
    is3D : true,
    title : chart_title,
    isStack : true
    });
}

    The drawColumnChart function allows to draw a column chart: 

     1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
    //Display a ColumnChart
function drawColumnChart(html_id, array_data, array_column, chart_title, chart_width, chart_height, isMultiChart) {
    /*If The column chart is not multi columns*/
    if (!isMultiChart) {
        var data = new google.visualization.DataTable();
        for (i = 0; i < array_column.length; i++) {
            data.addColumn(array_column[i].type, array_column[i].title);
        }
        var array_array_data = new Array();
        for (i = 0; i < array_data.length; i++) {
            array_array_data.push([array_data[i].label, array_data[i].value]);
        }
        data.addRows(array_array_data);
    } else {
        var array_column_title = new Array();
        for (i = 0; i < array_column.length; i++) {
            array_column_title[i] = array_column[i].title;
        }

        var lastResultArray = new Array();
        lastResultArray.push(array_column_title);

        for (i = 0; i < array_data.length; i++) {
            var array_data_value = new Array();
            array_data_value.push(array_data[i].label);

            for (key in array_data[i].value) {
            array_data_value.push(array_data[i].value[key]);
            }
            lastResultArray.push(array_data_value);
        }

        var data = google.visualization.arrayToDataTable(lastResultArray);
    }

    var chart = new google.visualization.ColumnChart(document.getElementById(html_id));
    chart.draw(data, {
    width : chart_width,
    height : chart_height,
    is3D : true,
    title : chart_title,
    isStack : true
    });
}

    Getting Started

    This represents the content of my collection:

    img1

    Let's assume that we want to display the number of cars per state. Therefore, we will use the aggregate function as follow:

     1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
    function load_get_stats() {
    var pipelines = [{
                        "$group" : {
                            "_id" : {
                                "State" : "$state"
                            },
                            "Total" : {
                                "$sum" : "$nb_of_cars"
                            }
                        }
                        }, {
                        "$project" : {
                            "STATE" : "$_id.State",
                            "TOTAL" : "$Total"
                            }
                        }
                    ];
    col_my_collection.aggregateCallback(pipelines, {}, load_stats_ok, load_stats_ko);
}

    The load_stats_ok function will pass aggregation result to both drawPieChart and drawColumnChart functions:

     1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
    function load_stats_ok(result) {

    var array_data = new Array();
    for (var i = 0; i < result.length; i++) {
        array_data.push({
        "label" : result[i].STATE,
        "value" : parseInt(result[i].TOTAL)
        });
    }
    var array_column = [{
                            "type" : "string",
                            "title" : "State"
                            }, {
                            "type" : "number",
                            "title" : "Total Nb Of Cars"
                            }
                        ];

    var html_id_pie_chart = "chart_div2";
    var html_id_column_chart = "chart_div1";
    var chart_title = "Total Nb Of Cars";
    var chart_width = 0;
    var chart_height = 240;

    drawPieChart(html_id_pie_chart, array_data, array_column, chart_title, chart_width, chart_height);
    drawColumnChart(html_id_column_chart, array_data, array_column, chart_title, chart_width, chart_height, false);
}

    The load_stats_ko function will pop up a message in case of error while loading data from the collection: 

    1
    function load_stats_ko(result) {alert("ko "+JSON.stringify(result));}

    Let's assume that we want to display the number of cars and the numbers of motors per state. Therefore, we will use the aggregate function as follow:

    The load_stats_multi_chart function will retrieve data to be shown in the charts from the collection:

     1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
    function load_stats_multi_chart() {

var my_pipelines = [{
        "$group" : {
            "_id" : {
                "State" : "$state"
            },
            "Total_Cars" : {
                "$sum" : "$nb_of_cars"
            },
            "Total_Motors" : {
                "$sum" : "$nb_of_motors"
            }
        }
        }, {
            "$project" : {
                "state" : "$_id.State",
                "TOTAL_CARS" : "$Total_Cars",
                "TOTAL_MOTORS" : "$Total_Motors"
            }
        }
    ];

col_my_collection.aggregateCallback(my_pipelines, {}, load_stats_multi_ok, load_stats_multi_ko);
}

    The load_stats_multi_ok function will pass aggregation result to drawColumnChart function:

     1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
    function load_stats_multi_ok(result) {

    var array_data_multi = new Array();
    var my_value = {};
    var value_array = new Array();
    for (var i = 0; i < result.length; i++) {
        my_value = {};
        my_value.TOTAL_CARS = parseInt(result[i].TOTAL_CARS);
        my_value.TOTAL_MOTORS = parseInt(result[i].TOTAL_MOTORS);
        value_array[i] = my_value;
    }

    for (var i = 0; i < result.length; i++) {
        array_data_multi.push({
        "label" : result[i].state,
        "value" : value_array[i]
        });
    }

    var array_column_multi = [{
                                "type" : "string",
                                "title" : "State"
                                }, {
                                "type" : "number",
                                "title" : "Total Nb Of Cars"
                                }, {
                                "type" : "number",
                                "title" : "Total Nb Of Motors"
                                }
                            ];

    var html_id = "chart_div3";
    var chart_title = "Total Nb Of Cars And Motors";
    var chart_width = 0;
    var chart_height = 240;

    drawColumnChart(html_id, array_data_multi, array_column_multi, chart_title, chart_width, chart_height, true);
}

    The load_stats_multi_ko function will pop up a message in case of error while loading data from the collection: 

    1
    function load_stats_multi_ko(result) {alert("ko "+JSON.stringify(result));}

    Data Structure

    The drawColumnChart function will take as input parameter an array with format as below:

    • In case it's a Multi-Chart:

    array_data structure will look like:

    1
2
3
    [{"label":"Arizona","value":{"TOTAL_CARS":4,"TOTAL_MOTORS":5}},
{"label":"Florida","value":{"TOTAL_CARS":2,"TOTAL_MOTORS":3}},
{"label":"Alaska","value":{"TOTAL_CARS":5,"TOTAL_MOTORS":3}}]

    array_column structure will look like:

    1
2
3
    [{ "type" : "string", "title" : "State" },
 { "type" : "number", "title" : "Total Nb Of Cars" },
 { "type" : "number", "title" : "Total Nb Of Motors" }]
    • In case it is not a Multi-Chart:

    array_data structure will look like:

    1
2
3
    [{"label":"Arizona","value":4},
{"label":"Florida","value":2},
{"label":"Alaska","value":5}]

    array_column structure will look like:

    1
2
    [{ "type" : "string", "title" : "State"},
 { "type" : "number", "title" : "Total Nb Of Cars"}]

    The drawPieChart function will take the same format of input parameter as for drawColumnChart / non-Multi-Chart.

    Important : The first column of column_array should have string as type. All other columns must have number as type.

    Web Interface

    Since we have the definitions of the functions, let's create our Web Interface. - Create a new Web Interface, title 'Dashboard'. - Go to JavaScript tab - Insert as HEADER the Google visualization library:

    1
    https://www.google.com/jsapi?autoload=%7B%22modules%22%3A%5B%7B%22name%22%3A%22visualization%22%2C%22version%22%3A%221%22%2C%22packages%22%3A%5B%22corechart%22%5D%7D%5D%7D

    img2

    1
    - Go to the Design tab:

    img3

    (1) Create a HTML widget with following code:

    1
    <div id="chart_div1"><div>

    (2) Create a HTML widget with following code:

    1
    <div id="chart_div2"><div>

    (3) Create a HTML widget with following code:

    1
    <div id="chart_div3"><div>

    (4) Create a hidden split widget

    (5) Create a Javascript widget containing all of the functions described above.

    This is the Javascript code to be used:

      1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
    //Display a PieChart
function drawPieChart(html_id, array_data, array_column, chart_title, chart_width, chart_height) {
    // Create our data table.
    var data = new google.visualization.DataTable();
    for (i = 0; i < array_column.length; i++) {
        data.addColumn(array_column[i].type, array_column[i].title);
    }
    var array_array_data = new Array();
    for (i = 0; i < array_data.length; i++) {
        array_array_data.push([array_data[i].label, array_data[i].value]);
    }
    data.addRows(array_array_data);
    // Instantiate and draw our chart, passing in some options.
    var chart = new google.visualization.PieChart(document.getElementById(html_id));
    chart.draw(data, {
    width : chart_width,
    height : chart_height,
    is3D : true,
    title : chart_title,
    isStack : true
    });
}

//Display a ColumnChart
function drawColumnChart(html_id, array_data, array_column, chart_title, chart_width, chart_height, isMultiChart) {
    /*If The column chart is not multi columns*/
    if (!isMultiChart) {
        var data = new google.visualization.DataTable();
        for (i = 0; i < array_column.length; i++) {
            data.addColumn(array_column[i].type, array_column[i].title);
        }
        var array_array_data = new Array();
        for (i = 0; i < array_data.length; i++) {
            array_array_data.push([array_data[i].label, array_data[i].value]);
        }
        data.addRows(array_array_data);
    } else {
        var array_column_title = new Array();
        for (i = 0; i < array_column.length; i++) {
            array_column_title[i] = array_column[i].title;
        }

        var lastResultArray = new Array();
        lastResultArray.push(array_column_title);

        for (i = 0; i < array_data.length; i++) {
            var array_data_value = new Array();
            array_data_value.push(array_data[i].label);

            for (key in array_data[i].value) {
            array_data_value.push(array_data[i].value[key]);
            }
            lastResultArray.push(array_data_value);
        }

        var data = google.visualization.arrayToDataTable(lastResultArray);
    }

    var chart = new google.visualization.ColumnChart(document.getElementById(html_id));
    chart.draw(data, {
    width : chart_width,
    height : chart_height,
    is3D : true,
    title : chart_title,
    isStack : true
    });
}

function load_get_stats() {
   var pipelines = [{"$group":{"_id":{"State":"$state"},"Total":{"$sum":"$nb_of_cars"}}},{"$project":{"STATE":"$_id.State","TOTAL":"$Total"}}];
 col_my_collection.aggregateCallback(pipelines ,{},load_stats_ok,load_stats_ko);
}


function load_stats_ok(result){
     var array_data = new Array();
     for (var i = 0; i < result.length; i++) {
     array_data.push({"label":result[i].STATE,"value":parseInt(result[i].TOTAL)});
     }
      var array_column = [{ "type" : "string", "title" : "State" }, { "type" : "number", "title" : "Total Nb Of Cars" } ];

     var html_id_pie_chart = "chart_div2";
     var html_id_column_chart = "chart_div1";
     var chart_title = "Total Nb Of Cars";
     var chart_width = 0;
     var chart_height = 240;

     drawPieChart(html_id_pie_chart, array_data, array_column, chart_title, chart_width, chart_height);
     drawColumnChart(html_id_column_chart, array_data, array_column, chart_title, chart_width, chart_height,false);
}

function load_stats_ko(result) {alert("ko"+JSON.stringify(result));}

function load_stats_multi_chart() {

 var my_pipelines = [{"$group":{"_id":{"State":"$state"},"Total_Cars":{"$sum":"$nb_of_cars"},"Total_Motors":{"$sum":"$nb_of_motors"}}},{"$project":{"state":"$_id.State","TOTAL_CARS":"$Total_Cars","TOTAL_MOTORS":"$Total_Motors"}}];

 col_my_collection.aggregateCallback(my_pipelines, {}, load_stats_multi_ok, load_stats_multi_ko);
}
function load_stats_multi_ok(result){

 var array_data_multi = new Array();
 var my_value = {};
 var value_array = new Array();
 for (var i = 0; i < result.length; i++) {
 my_value = {};
 my_value.TOTAL_CARS = parseInt(result[i].TOTAL_CARS);
 my_value.TOTAL_MOTORS = parseInt(result[i].TOTAL_MOTORS);
 value_array[i] = my_value;
 }

 for (var i = 0; i < result.length; i++) {
 array_data_multi.push({"label":result[i].state,"value":value_array[i]});
 }

 var array_column_multi = [{ "type" : "string", "title" : "State" }, { "type" : "number", "title" : "Total Nb Of Cars" },{ "type" : "number", "title" : "Total Nb Of Motors" } ];

 var html_id = "chart_div3";
 var chart_title = "Total Nb Of Cars And Motors";
 var chart_width = 0;
 var chart_height = 240;

 drawColumnChart(html_id, array_data_multi, array_column_multi, chart_title, chart_width, chart_height, true);
}

function load_stats_multi_ko(result) {alert("ko"+JSON.stringify(result));}

load_get_stats();
load_stats_multi_chart();

    Do note, you will have to replace the following parameters with your own values: - Charts labels/title - The value true/false in the drawColumnChart function will indicate if the data structure sent to the function represents a single column or an array of columns.

    Save your Web Interface and preview it.

    Note: Every chart will need its associated chart_divXX HTML div id to be displayed.