Multi-Queries for Grafana Time Series Plot \query endpoint

[wicky818]

Hello there,

I successfully got visualizations following the examples from the documentation with one single query. However, I'd like to pass in a second query to visualize both queries (for duel axis visualization), but I don't know what format the two response arrays need to be in.

I am currently using a Python Flask API and trying to match up the data format that Grafana/ the Plugin is expecting. Here's a snapshot of the 2 request queries (refId: "A" & refId: "B") and the response format that I have at the moment that does not work under the response['results'] object.

Is there an example of 2 request['targets'] objects or queries with 2 response arrays/objects that work with this plugin and the time-series Grafana panel?

I really appreciate all your help!

[simPod]

I wonder why it does not work? I use panels with several targets all the time.

My response with several series looks like follows:

[wicky818]

Hey, thank you for the quick response! Yes, I was able to get it to work when I have 1 query returning multiple series. But when I try to have 2 queries with each having multiple series, I cannot get it to work. Do I have to collate the results from the separate JSON queries into one list of objects (basically I'm trying to make a plot with a left-y-axis of count and a right-y-axis of some floating point value)?

Here's a snapshot of an example for 2 queries to achieve a duel-y-axis plot.

[simPod]

My panels sends two queries:

{
   "app":"panel-viewer",
   "requestId":"mixed-0-Q106",
   "timezone":"utc",
   "panelId":1,
   "dashboardUID":"fe7cac66503ff201a92bbb1e8d66c666",
   "publicDashboardAccessToken":"",
   "range":{
      "from":"2023-06-18T10:21:46.836Z",
      "to":"2023-06-20T10:21:46.836Z",
      "raw":{
         "from":"now-2d",
         "to":"now"
      }
   },
   "timeInfo":"",
   "interval":"2m",
   "intervalMs":120000,
   "targets":[
      {
         "alias":"",
         "datasource":"JSON",
         "payload":{
            "timeseries_group_by":"none",
            "force_second_y_axis":true,
            "panel_type":"timeseries"
         },
         "refId":"A",
         "target":"T1"
      },
      {
         "alias":"",
         "datasource":"JSON",
         "payload":{
            "timeseries_group_by":"none",
            "force_second_y_axis":true,
            "panel_type":"timeseries"
         },
         "refId":"B",
         "target":"T2"
      }
   ],
   "maxDataPoints":1170,
   "scopedVars":{
      "xxx":{
         "selected":false,
         "text":"4031a1b9-940f-435b-bb9d-1e15b84869f1",
         "value":"4031a1b9-940f-435b-bb9d-1e15b84869f1"
      },
      "__interval":{
         "text":"2m",
         "value":"2m"
      },
      "__interval_ms":{
         "text":"120000",
         "value":120000
      }
   },
   "startTime":1687256506836,
   "rangeRaw":{
      "from":"now-2d",
      "to":"now"
   },
   "adhocFilters":[
      
   ]
}

and returns 14 series total with no issues what so ever