Plot more than one series on the same time series

Grafana Time Series Panel
,
1

I have multiple servers reporting a value(Temperature or reliability score). I want to plot them on the same time series. value over time for each metric.

the table looks like this

image
image591×971 63.5 KB

reading a few of the posts here it looks like

SELECT
time AS “time”,
reliability as value,
machine_id as metric
FROM machine
WHERE
$__unixEpochFilter(time)
GROUP BY machine_id,time
ORDER BY time asc

but this does not work. if I remove the grouping to plot the two columns. not two series base in matric

2

I can do this with a query for each system but as I don’t know how many servers there will be or what there machine_IDs will be I need to find a way for tot to group it

3 
SELECT
  time AS "time",
  reliability AS value,
  CONCAT(machine_id, '') AS metric
FROM machine
WHERE
  $__unixEpochFilter(time)
ORDER BY time

This worked