×

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

    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!!