Hi, I have seen a video on Running a Power Plant with Grafana - YouTube , in which at 11:53 you can see the graph: [image] I have a dataset with columns: datetime, modem, tap_id, tap_val. For example: dtime |modem|tap_nr|tap_val| -------------------|-----|------|-------| 2020-0…

Guys, this has not been said much anywhere on Grafana forums/communities/Managed Services. But let me solve this problem once and for all. You can have multiple lines on a single graph (through a single query) and group them by a metric by selecting a specific transformation called ‘Prepare Time Se…

Unless I misunderstand the issue all you need to do is to create a query for each line.

I don’t know in advance how many lines I will have. It depends on variable selection and filtering. I cannot hardcode the queries.

[image] gluperegistracije: I don’t know in advance how many lines I will have. In that case perhaps it would be a good idea to rephrase the thread title and the question. Perhaps it is clear from the video but very few are going to be bothered to watch a video. My suggestion answers all the…

Well, from the whole video, only the picture I have put here is important. As English is not my first language, I really don’t know how to rephrase the question. If you have an idea, please tell, I will change it. You answer is correct but it is not feasible to me because number of queries is dyn…

The missing bit is the use of the word dynamic. The graph shown from the video can be accomplished just by specifying the queries, unless you need the queries generated dynamically.

Yes, graph on the picture has 12 groups, so 12 queries would be OK. In my case I have (at the moment) cca 300 groups, and that number vary (in the future it will be larger).

You can use variables to parameterise queries to select which data you want to see, but I presume you have already investigated that.

[image] Variables Variables Variables allows for more interactive and dynamic dashboards. Instead of hard-coding things like server, application and sensor name in your metric queries you can use variables in their place. Variables are shown as dropdown select boxes... …

This thread is already old, but in case someone else is struggling with similar problem, here’s my 5 cents. If I understood the question correctly, I have managed to achieve something similar this way: In the query settings: Remove the filtering condition (where modem=M1) Add “Group by”: tag(mod…

[image] tonzero: his setting will make it look better (please try with and without this setting and you will notice the difference). Is the alias by available for all datasources ? I have a similar simpler question here : Dynamic legend values based on data column

How to plot multiple time series with the same time on the same graph?

yosiasz February 14, 2023, 9:24pm 15

Welcome

You might want to start a new thread as this one is closed. But that said trying using Transformation > Prepare Time Series and choose multi-frame

Topic		Replies	Views
Multi-series Line Graph with a single query Time Series Panel	0	2646	August 31, 2021
Multiple time series on one graph using one dynamic query Time Series Panel	1	26601	January 11, 2023
How to automatically extract and draw timeseries from different queries in a single panel? Dashboards	2	406	September 27, 2022
MS-SQL: Visualize multiple series in Time Series Graph panel with multi-value variable in query statement? MSSQL	2	1482	July 29, 2024
Time Series Not Working With Multiple serie in a Single query being reported as a single series Time Series Panel	1	1216	April 8, 2023

How to plot multiple time series with the same time on the same graph?

Related topics