Hello,

You can calculate the average by summing up the values in the metric field based on the mode that you are after.

The exact syntax would depend on what framework or programming language you are using.

The response that you would get would look something like this:

{
  "status": "success",
  "data": {
    "resultType": "matrix",
    "result": [
      {
        "metric": {
          "host_id": "222651441",
          "mode": "idle"
        },
        "values": [
          [
            1635386880,
            "122901.18"
          ],
          [
            1635387000,
            "123020.92"
          ],
          [
            1635387120,
            "123140.8"
          ]
        ]
      },
...
    ]
  }
}

Under the values array, you have 2 items:

• The time when the value was recorded in UNIX time
• The actual value

You can use a JSON parser to parse the information and get all of the values and sum them up based on your exact requirements.

Hope that this helps
Best,
Bobby