hi
This is a beautiful tool but,
Can a filter list be used to filter the data sources records?
Can you provide an example to use a REST/ODATA data source
Can 2 REST data sources be applied to a line chart and each display a line?
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
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]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();
}[/code]
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