App Studio - Dashboard - Create Calculated Fields

Client-side you could use in a row-update an expression to get the count of rows in a dataview like so:

%YourDataView.count%

or an aggregator js function to sum values of those rows like so

trans.dataView('YourDataView').data.reduce((sum, item) => sum + item.QuoteHed_QuoteAmt, 0)

Or aggregate by key like so

trans.dataView('PartCountsByVer').data.reduce((a, x) =>
  (a[x.Part_CommercialCategory] = (a[x.Part_CommercialCategory] || 0) +
     x.Calculated_CountOfPartNum, a), new Object()).PIPE

2 Likes