'Kusto query loop over json array

I want to loop over a JSON array like this:

[
  {
    "id": 1,
    "count" : 30
  },
  {
    "id": 2,
    "count" : 10
  },
  {
    "id": 3,
    "count" : 5
  },
  {
    "id": 4,
    "count" : 15
  }
]

So I would like to have a query to project a TotalCount which would basically go over the json array and sum all the count values(30+10+5+15) and display as a new column

azure-data-explorer


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions