Hello Colleagues,
I have a case where i need to combine two queries into 1 table but both from different measurements (influexdb DBs).
Details:
Data source: influexDB
- Query:
SELECT last(“status”) AS “status”, “version” FROM “http” WHERE (“url” =~ /.10.30./) AND $timeFilter GROUP BY “url”
Grafana format type : table
- Query:
SELECT last(“http_response_code”) FROM “http_response” WHERE (“server” =~ /^url_name/) AND $timeFilter GROUP BY server
Grafana format type : table
Any advise how can combine this 2 data queries into 1 table at grafana?