Hello. I am using Grafana v10.0.0 and am trying to make a time series to graph hosts and their CPU usage. But I think Grafana is combining the results of the two hosts I’m querying for into a single line, instead of creating two lines for two hosts. Here is my SQLite data source. “timestamp” is…

Ugh… sorry, there appears to have been an underlying problem with the database. I had planned the schema with hostname to have a TEXT data type , but somewhere along the way it got defined as an INTEGER field instead (!) SQLite is flexible enough to store text data in the field anyway, but the IN…

[image] dwhite21: SELECT hostname as metric, timestamp, cpu_load_avg as value FROM stats WHERE hostname=‘myhost1’ OR hostname=‘myhost2’ ORDER BY timestamp try: SELECT hostname as hostname, timestamp, cpu_load_avg as metric FROM stats WHERE hostname=‘myhost1’ OR hostname=‘myhost2’ ORDER BY ti…

yosiasz, thanks, but the query below didn’t seem to change the graph. SELECT hostname as metric, timestamp as [time], cpu_load_avg as value FROM stats WHERE hostname='myhost1' OR hostname='myhost2' ORDER BY timestamp [Screenshot 2024-03-12 124641]

Thanks, sowdenraymond, but that query doesn’t seem to affect much (the labels change, but there’s still no “hostname” listed and the metrics for the two hosts are still combined into a single line) SELECT hostname as hostname, timestamp, cpu_load_avg as metric FROM stats WHERE hostname='myhost1' …

ok next step try this transformation [image]

Like this? It doesn’t seem to make a difference to the graph. [Screenshot 2024-03-12 132306] and again when I look at the table view, there are no values for “metric” at all. [Screenshot 2024-03-12 132423]

How do I keep Grafana from combining multiple metrics into a single line?

Grafana Time Series Panel

yosiasz March 12, 2024, 6:08am 2

Also do select timestamp as [time]

Topic		Replies	Views
Single element produces multiple lines on graph Time Series Panel	1	515	April 6, 2023
Query related to Timeseries Time Series Panel	5	451	September 14, 2022
Multiple metric tables with OpenTSDB Grafana	3	1071	March 5, 2019
Multi-series Line Graph with a single query Time Series Panel	0	2611	August 31, 2021
Possible to combine two lines into one? InfluxDB	2	332	February 3, 2024

How do I keep Grafana from combining multiple metrics into a single line?

Related topics