×

Please give details of the problem

Docs

Find

    Developer Guide

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

    Charts Dashboard

    To configure a RunMyProcess dashboard with pie and column charts, we'll use Google Visualisation for chart rendering, and as source of data RunMyProcess reports feeds.

    Configure reports

    You already have several process instances on your account. Let's create a groupby report corresponding to the PieChart to be displayed.

    In this example, the main process is 'RFP flow' with a set of measures including 'Company'.

    To create a groupby process report to display Nb of RFP by Company:

    • Go to PROJECT > NEW > REPORT > PROCESS REPORT

    • Edit process report configuration:

    2013-01-11_161325

    • Then hit 'search result' to display data:

    2013-01-11_161411

    • Then click on rss feed 2013-01-11_161723 , this should display rss feed url + feed data in a new tab:

    2013-01-11_162214

    • Your feed url should look like:

    https://live.runmyprocess.com/live/621593453/analysis/process/COUNT? field=NUMBER&group=MEASURE_4&operator=EE%20EE%20NE%20IS%20EE&value=46610%20TEST%20%20NULL %2073086&filter=PROJECT%20MODE%20MEASURE_4%20PARENT%20PROCESS

    • As you can see, it contains all the filters you've configured. Do try to open in a new tab this url adding &media=json at the end:

    https://live.runmyprocess.com/live/621593453/analysis/process/COUNT? field=NUMBER&group=MEASURE_4&operator=EE%20EE%20NE%20IS%20EE&value=46610%20TEST%20%20NULL %2073086&filter=PROJECT%20MODE%20MEASURE_4%20PARENT%20PROCESS&media=json

    Let's give this url the name json_report_feed_url

    • This should display the same feed with json output (instead of xml output):

    2013-01-11_162551

    Note: if you are a Chrome user, you can use JSONView plugin to pretty print json feed

    Now you have your source of data, let's create the webinterface to display the dashboard containing the PieChart

    Configure Dashboard webinterface: embed a PieChart

    • Create a new Webinterface, title 'Dashboard'.

    • Go to Javascript tab:

    2013-01-11_164631

    (1) Insert as HEADER the google visualisation library

    1
    2
    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
    

    (2) Insert as FOOTER the jQuery library to perform AJAX calls:

    1
    https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js
    
    • Go to the Design tab

    2013-01-11_164539

    (1) Create a html widget with following code:

    Code

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

    This is the html area to display the PieChart.

    (2) Create a hidden split widget

    (3) Create a js widget with following code:

    Code

     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
    //Handle 0,1 or several records from report feed
    
    function get_array(my_father, my_son) {
    if (typeof(my_father) == "object") {
    if (my_father[my_son] != undefined) {
    if (my_father[my_son].length != undefined) {
    var my_array = my_father[my_son];
    } else {
    var my_array = [my_father[my_son]];
    }
    } else {
    var my_array = [];
    }
    } else {
    var my_array = [];
    }
    return my_array;
    }
    
    //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
     });
    }
    
    //Get report feed and then render the PieChart 1
    
    function draw_Pie1() {
     $.ajax({
     type : "GET",
     url : "json_report_feed_url",
     data : {},
     cache : false,
     async : true,
     dataType : "json",
     error : function () {
     alert('Error while loading credits.');
     },
     success : function (P_result) {
     var array_column = [{
     "type" : "string",
     "title" : "Company"
     }, {
     "type" : "number",
     "title" : "Nb RFP"
     }
     ];
     var my_entries = get_array(P_result.feed.entry.content.data, "result");
     var array_data = new Array();
     for (var i = 0; i < my_entries.length; i++) {
     array_data.push({
     "label" : my_entries[i].serie.value,
     "value" : parseFloat(my_entries[i].value)
     });
     }
     //alert(JSON.stringify(array_data));
     var html_id = "chart_div1";
     var chart_title = "Nb of RFP by Company";
     var chart_width = 0;
     var chart_height = 240;
     drawPieChart(html_id, array_data, array_column, chart_title, chart_width, chart_height);
     }
     });
    }
    
    //init charts
    
    draw_Pie1();
    

    In red, the code to replace:

    • charts labels/title

    • json_report_feed_url (cf previous chapter)

    • chart_div1 if you used a different name

    Save your webinterface and preview it.

    Note: Every chart will need its associated chart_divXX id to be diplayed.

    Note2: To create another PieChart, it's just about adding another draw_Pie2() function and include another chart_div2 html div.

    Other charts: embed a ColumnChart

    Column chart can be displayed using the same data feed. You just need a group by report as for the PieChart.

    To render a ColumnChart you can add the 2 following functions to previous script:

    Code

     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
    //Display a ColumnChart
    
    function drawColumnChart(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.ColumnChart(document.getElementById(html_id));
     chart.draw(data, {
     width : chart_width,
     height : chart_height,
     is3D : true,
     title : chart_title
     });
    }
    
    //Get report feed and then render the ColumnChart 2
    
    function draw_ColumnChart2() {
     $.ajax({
     type : "GET",
     url : "json_report_feed_url2",
     data : {},
     cache : false,
     async : true,
     dataType : "json",
     error : function () {
     alert('Error while loading credits.');
     },
     success : function (P_result) {
     var array_column = [{
     "type" : "string",
     "title" : "Company"
     }, {
     "type" : "number",
     "title" : "RFP amount"
     }
     ];
     var my_entries = get_array(P_result.feed.entry.content.data, "result");
     var array_data = new Array();
     for (var i = 0; i < my_entries.length; i++) {
     array_data.push({
     "label" : my_entries[i].serie.value,
     "value" : parseFloat(my_entries[i].value)
     });
     }
     //alert(JSON.stringify(array_data));
     var html_id = "chart_div2";
     var chart_title = "RFP amount by Company";
     var chart_width = 0;
     var chart_height = 240;
     drawColumnChart(html_id, array_data, array_column, chart_title, chart_width, chart_height);
     }
     });
    }
    

    The same red code has to be replaced.

    To both render PieChart & ColumnChart:

    Code

    1
    2
    3
    //init
    draw_Pie1();
    draw_ColumnChart2();
    

    Enjoy!!