×

Please give details of the problem

Docs

Find

    Developer Guide

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

    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.


    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.