JQ Example: group by + count

Your JSON content

{
  "calls": [
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 28,
      "path": "/users/14839"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 143,
      "path": "/products/18163"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 114,
      "path": "/products/17067"
    },
    {
      "route": "/companies",
      "resultCode": 200,
      "callTimeMs": 180,
      "path": "/companies/16990"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 173,
      "path": "/products/10264"
    },
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 39,
      "path": "/users/4320"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 39,
      "path": "/products/11779"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 212,
      "path": "/products/15928"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 161,
      "path": "/users/1294"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 159,
      "path": "/users/759"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 128,
      "path": "/users/10081"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 215,
      "path": "/users/16658"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 85,
      "path": "/products/8269"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 113,
      "path": "/users/18568"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 179,
      "path": "/products/18339"
    },
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 171,
      "path": "/users/9549"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 63,
      "path": "/users/9353"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 114,
      "path": "/companies/3582"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 178,
      "path": "/products/2689"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 148,
      "path": "/companies/6359"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 93,
      "path": "/users/5243"
    },
    {
      "route": "/companies",
      "resultCode": 200,
      "callTimeMs": 22,
      "path": "/companies/694"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 187,
      "path": "/users/4534"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 176,
      "path": "/products/17537"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 74,
      "path": "/products/13842"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 29,
      "path": "/products/11155"
    },
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 136,
      "path": "/users/2153"
    },
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 107,
      "path": "/users/1191"
    },
    {
      "route": "/companies",
      "resultCode": 200,
      "callTimeMs": 53,
      "path": "/companies/6956"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 32,
      "path": "/products/12711"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 170,
      "path": "/products/15674"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 162,
      "path": "/companies/11866"
    },
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 219,
      "path": "/users/16457"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 167,
      "path": "/products/12122"
    },
    {
      "route": "/companies",
      "resultCode": 200,
      "callTimeMs": 49,
      "path": "/companies/2182"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 145,
      "path": "/users/8593"
    },
    {
      "route": "/companies",
      "resultCode": 200,
      "callTimeMs": 56,
      "path": "/companies/6598"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 82,
      "path": "/users/8215"
    },
    {
      "route": "/companies",
      "resultCode": 200,
      "callTimeMs": 191,
      "path": "/companies/17894"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 206,
      "path": "/companies/2931"
    },
    {
      "route": "/companies",
      "resultCode": 200,
      "callTimeMs": 165,
      "path": "/companies/9516"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 59,
      "path": "/companies/18403"
    },
    {
      "route": "/users",
      "resultCode": 500,
      "callTimeMs": 211,
      "path": "/users/2117"
    },
    {
      "route": "/products",
      "resultCode": 200,
      "callTimeMs": 218,
      "path": "/products/9113"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 200,
      "path": "/products/1690"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 33,
      "path": "/users/18600"
    },
    {
      "route": "/companies",
      "resultCode": 500,
      "callTimeMs": 33,
      "path": "/companies/1601"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 35,
      "path": "/products/1100"
    },
    {
      "route": "/users",
      "resultCode": 200,
      "callTimeMs": 22,
      "path": "/users/7421"
    },
    {
      "route": "/products",
      "resultCode": 500,
      "callTimeMs": 209,
      "path": "/products/9999"
    }
  ]
}

Cheatsheet

Expression

FAQContact Us