JQ Example: group by + add

Your JSON content

{
  "calls": [
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 183,
      "path": "/products/1188"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 183,
      "path": "/users/16006"
    },
    {
      "route": "/companies",
      "resultCode": 200,
      "callTimeMs": 209,
      "path": "/companies/11913"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 62,
      "path": "/companies/9379"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 26,
      "path": "/companies/12496"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 114,
      "path": "/users/3318"
    },
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 204,
      "path": "/users/606"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 33,
      "path": "/users/16876"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 192,
      "path": "/companies/9181"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 88,
      "path": "/companies/18279"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 20,
      "path": "/companies/10427"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 55,
      "path": "/products/7335"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 49,
      "path": "/products/10561"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 72,
      "path": "/products/12913"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 125,
      "path": "/products/8377"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 36,
      "path": "/companies/812"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 98,
      "path": "/companies/7011"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 55,
      "path": "/products/14759"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 81,
      "path": "/companies/15054"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 191,
      "path": "/users/14785"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 22,
      "path": "/products/17932"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 213,
      "path": "/products/15127"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 43,
      "path": "/products/14176"
    },
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 33,
      "path": "/users/8708"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 34,
      "path": "/products/3126"
    },
    {
      "route": "/companies",
      "resultCode": 200,
      "callTimeMs": 217,
      "path": "/companies/10492"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 162,
      "path": "/companies/4748"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 178,
      "path": "/users/1646"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 182,
      "path": "/products/11313"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 127,
      "path": "/products/11813"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 152,
      "path": "/products/14761"
    },
    {
      "route": "/companies",
      "resultCode": 200,
      "callTimeMs": 75,
      "path": "/companies/15925"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 156,
      "path": "/products/2598"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 59,
      "path": "/users/12845"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 212,
      "path": "/products/2651"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 84,
      "path": "/companies/7019"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 88,
      "path": "/users/2643"
    },
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 125,
      "path": "/users/8349"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 181,
      "path": "/users/14722"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 87,
      "path": "/products/2956"
    },
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 119,
      "path": "/users/13541"
    },
    {
      "route": "/companies",
      "resultCode": 200,
      "callTimeMs": 30,
      "path": "/companies/10930"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 198,
      "path": "/products/14220"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 151,
      "path": "/products/15330"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 136,
      "path": "/products/8400"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 83,
      "path": "/users/13155"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 63,
      "path": "/users/3109"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 66,
      "path": "/products/12378"
    },
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 201,
      "path": "/users/15412"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 107,
      "path": "/products/15349"
    }
  ]
}

Cheatsheet

Expression

FAQContact Us