Average numeric field

bash

echo '[{"score":80},{"score":90},{"score":100}]' | jq '(map(.score) | add) / length'

Explanation

Simple but common analytics pattern.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Grouping and Aggregation

Sum one field across an array of objects.

Open In sheetbashsame section

Build a frequency table from array objects.

Open In sheetbashsame section

Find objects with smallest and largest values.

Open In sheetbashsame section

Split one array into matching and non-matching groups.

Open In sheetbashsame section

Get the first element.

Open In sheetbash1 tag match

Return all object values as an array.

Open In sheetbash1 tag match