Forums

Full Version: Aggregating Data through CSV/Excel in Dashboard Designer
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
How can we aggregate the data which we get through CSV/Excel in Dashboard Designer?
(06-17-2019, 06:04 PM)noopur.mehrotra Wrote: [ -> ]How can we aggregate the data which we get through CSV/Excel in Dashboard Designer?

By writing scripts on connection of CSV/Excel, you can aggregate:-


sdk.applyAggregation("bar32", "Year", "Revenue,Expenses", "SUM,SUM");
Use the function to apply aggregation on dataset of chart/ grid. These are the available aggregation operations - SUM, AVG, MAX, MIN, COUNT