Forum Discussion
2 Replies
Sort By
- MCFNeilQrew CaptainWhat are some of the 'preliminary' levels of summed groupings? you might be able to inject a parent table somewhere in the mix, and summarize the date before your build the reports.
If you can provide some more details of the data you are dealing with, and the output desire, we should be able to come up with something. - _anomDiebolt_Qrew EliteUse script. It is a four step procedure:
(1) use API_DoQuery to gather the raw un-aggregated data in XML
(2) convert XML to JSON
(3) use Underscore to aggregate / summarize / process / calculate with your JSON data. Underscore is a Swiss army knife for processing data and includes methods for groupBy(), sortBy(), IndexBy(), CountBy() and every manner of filtering and aggregation you could think of. See: http://underscorejs.org/
(4) render your resulting JSON to HTML or post it to a table using API_AddRecord or API_ImportFromCSV