JSON Array Group-By / Aggregate Tool
Paste a JSON array of objects, pick a group-by field and an aggregate field, and get sum, average, min, max or count per group.
Advertisement
About this tool
Groups every object in the array by the value of your chosen field, then applies the selected aggregate function to the aggregate field within each group. Non-numeric or missing values in the aggregate field are skipped from sum/average/min/max calculations (with a note showing how many were skipped) but still counted toward the group's item count.