Forum Discussion

PaulTimmins's avatar
PaulTimmins
Qrew Trainee
8 years ago

creating fields based on summary total columns. Does anyone have a workaround with this limitation?

We are facing consistent walls in getting some simple calculations from a summary total reporting level. We have created numerous summary reports but cannot do simple calcs using the summarised totals...
APIs and custom code
App builders
Formulas and functions
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
Use 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