Free · Find the mean of a number field

JSON Average Calculator

Calculate the simple average of numbers collected from JSON records.

Real JSONata 2.2 query
Private in your browser
Time and result safety caps

Calculate JSON average

Paste JSON, edit the JSONata expression, and run it locally with time, depth, and result limits.

Add JSON and a queryBoth stay in this browser tab

JSON data 1,255 / 120,000 characters

{
  "store": {
    "name": "Little Leaf Market",
    "currency": "CAD"
  },
  "orders": [
    {
      "id": "A-100",
      "customer": "Mia",
      "city": "Toronto",
      "status": "paid",
      "total": 84.5,
      "items": 3,
      "tags": [
        "gift",
        "new"
      ]
    },
    {
      "id": "A-101",
      "customer": "Noah",
      "city": "Ottawa",
      "status": "pending",
      "total": 42,
      "items": 1,
      "tags": [
        "new"
      ]
    },
    {
      "id": "A-102",
      "customer": "Ava",
      "city": "Toronto",
      "status": "paid",
      "total": 126.25,
      "items": 4,
      "tags": [
        "vip",
        "gift"
      ]
    },
    {
      "id": "A-103",
      "customer": "Liam",
      "city": "Montreal",
      "status": "refunded",
      "total": 58.75,
      "items": 2,
      "tags": [
        "return"
      ]
    },
    {
      "id": "A-104",
      "customer": "Emma",
      "city": "Ottawa",
      "status": "paid",
      "total": 199,
      "items": 5,
      "tags": [
        "vip"
      ]
    },
    {
      "id": "A-105",
      "customer": "Mateo",
      "city": "Toronto",
      "status": "pending",
      "total": 72.25,
      "items": 2,
      "tags": [
        "gift"
      ]
    }
  ]
}

JSONata expression 22 / 1,000 characters

Bounded local queryJSONata 2.2.2 · 800 ms timeout · $eval off

See the resultReady when you are

Your query result will appear here

JSONata can filter, sort, group, calculate, and reshape the sample without an upload.

Three simple steps

How to use it

Paste JSON with a number path.
Point $average at those numbers.
Check missing values before using the result.

Your JSON stays on this device

JSONata reads and transforms the JSON inside this browser tab. Bookify does not upload or save the data or expression. Every run has time, sequence, stack, input, and output limits, and $eval stays disabled.