Hi guys, I am trying to plot several timeseries using the timeseries panel. I query the data from PostgreSQL and get a table with colums ts, node, delay_ms. I would like to plot as many lines as different “node” values, and for each line plot the (ts, delay_ms) points. No matter what I try, it always plots just one line, ignoring the “node” column. How could I solve that? I am using Grafana 10.
Try using the Prepare time series transformation with the Multi-frame time series option. You might need to cast the node column to a non-number type in the SQL query to avoid Grafana confusing it with a value column.
Select ts as [time], node as metric, delay_ms as value
And make sure to choose the Format of time series rather than Table
