How to process a JSON payload to convert it into a time series visualization using Infinity data source

Grafana Time Series Panel
1

  • What Grafana version and what operating system are you using?
    Grafana v9.2.2 Windows 11

  • What are you trying to achieve?
    A time series visualization out from a JSON payload retrieved using HTTP request with Infinity data source.

  • How are you trying to achieve it?

  • What happened?
    A single point appears instead of plotting the series.

  • What did you expect to happen?
    To have plot a series.

  • Can you copy/paste the configuration(s) that you are having problems with?

    image
    image1020×422 28.6 KB

    image
    image993×181 16.6 KB

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

The data comes in the following shape:

[
   {
      "metricId":352528,
      "metricName":"aaa",
      "metricPath":"aaa",
      "frequency":"SIXTY_MIN",
      "metricValues":[
         {
            "startTimeInMillis":1702044000000,
            "occurrences":1,
            "current":2730,
            "min":0,
            "max":9613,
            "useRange":true,
            "count":64905,
            "sum":5836044,
            "value":90,
            "standardDeviation":0
         },
         {
            "startTimeInMillis":1702049000000,
            "occurrences":1,
            "current":2740,
            "min":0,
            "max":9617,
            "useRange":true,
            "count":64935,
            "sum":5836074,
            "value":80,
            "standardDeviation":0
         }
      ]
   }
]