I have 2 Time ranges with specific data which i want to compare in a Table. I have written 2 queries, but each entry appears in different row. See below
Metric | Run1 | Run2
CPU Average | 5% | -
CPU Average | - | 8%
Memory Average | 80% | -
Memory Average | - | 85%
Query 1:
SELECT percentile(“value”, 100) AS “BL_PASS” FROM “es_tr_trpass” WHERE (“QcRunId” =~ /^Baseline_RunId/ AND “MeasurementName” =~ /^measurement/) AND $timeFilter GROUP BY “MeasurementName”
Query 2:
SELECT percentile(“value”, 100) AS “PASS” FROM “es_tr_trpass” WHERE (“QcRunId” =~ /^Current_RunID/ AND “MeasurementName” =~ /^measurement/) AND $timeFilter GROUP BY “MeasurementName”
Source: InfluxDB