Aggregating Budget Data

Overview

Once a budget has been compiled, it may be necessary to do some aggregation on the data.

Aggregating Budgets by Category

let totals = $list(budget).group(p=>p.category).map(p=>{
  return {
    category:p.keys[0],
    value:$list(p.values).map(p=>p.value).sum()
  };
}).items;
				

Try it!