Multiple timeseries in single panel for sql server

Grafana Dashboards
1

Hi all,

I am currently using Grafana v9.3.2 running as a docker container and trying to understand the best way to visualise some data.

What I would like to be able to do is show multiple timeseries in a single panel (sounds so simple!). I’m currently storing data in a sql server table like this:

Timestamp | Metric | Value
18:20:02 | MetricA | 30
18:20:02 | MetricB | 15
18:20:02 | MetricC | 10
18:20:03 | MetricA | 32
18:20:03 | MetricB | 17
18:20:03 | MetricC | 12
18:20:04 | MetricA | 34
18:20:04 | MetricB | 19
18:20:04 | MetricC | 14

I have the below query, but I’m not sure how to produce a timeseries line per Metric:

SELECT
$__time(“Timestamp”),
“Value”
FROM MetricTable
WHERE $__timeFilter(“timestamp”) and Metric in ($Metics)
ORDER BY Timestamp ASC

Which results in this:

image
image1188×863 86.1 KB

Is there a way to achieve this with sql server, or is there a better datasource option I should use instead?

Many thanks,
Mike

2

That is possible.

In the transformation tab, selecr seeies then choose data frame