2+ REST Datasources

by gwinterhalter@epmsolutions.com » Thu Jun 09, 2016 7:18 pm

hi

This is a beautiful tool but,

1. Can a filter list be used to filter the data sources records?

2. Can you provide an example to use a REST/ODATA data source

3. Can 2 REST data sources be applied to a line chart and each display a line?

4. For a line chart with date for X axis and Y axis for Cost. Can cost be shown as a running total?

Can you provide examples for above. Thanks

Greg
gwinterhalter@epmsolutions.com
 
Posts: 1
Joined: Thu Jun 09, 2016 7:06 pm

by Dmitry Kozlov » Sun Jun 12, 2016 7:47 pm

Hello Greg,

Please, find my answers below:

1. Can a filter list be used to filter the data sources records?

Yes, you can select a filtered view in the Data Source -> SharePoint List tab of Dashboard Designer. Please, watch the video:
https://www.youtube.com/watch?v=PLK4UHSLsWo

2. Can you provide an example to use a REST/ODATA data source

Yes, clear the SharePoint site in the Data Source -> SharePoint List and put the following code into Data Source -> Advanced tab:

Code: Select all
var handlers = {};
handlers.init = function(data, logger) {
  var result = $.Deferred();
 
  $.ajax({
    url: '/external_web_service/file.data',
    type: 'GET'
  })
  .done(function (content) {
    try {
      var items = jsonDates.parse(content);
      data.items = items;
    } catch (e) {}
  })
  .always(function() {
    result.resolve();
  });
 
  return result.promise();
}


Here, we use an external web service as data source.

3. Can 2 REST data sources be applied to a line chart and each display a line?

Yes, you can retrieve data from both services in the handlers.init handler and then group by data source in the Data Source -> Aggregation tab:
http://www.spchart.com/documentation/data-source/advanced

4. For a line chart with date for X axis and Y axis for Cost. Can cost be shown as a running total?

Yes, use Date aggregation options in the Dashboard -> Chart tab:
http://www.spchart.com/documentation/dashboard/chart
User avatar
Dmitry Kozlov
 
Posts: 129
Joined: Wed Nov 12, 2014 3:24 pm


Return to Dashboard Designer for SharePoint 2013

cron