Sqlite plugin - How to change display name of multiple series

[kroa38]

Hello,

i have multiple series from a sqlite database but i don’t know how to change the displayed name

Actually all the curve have the same Name “Rssi”

Grafana v 11.6.1
Sqlite Plugin : 3.5.0 (2024-03–08)

Thanks a lot for your help
Franck

[infofcc3]

for all 4 different query you can give name like this…

[infofcc3]

Hello @kroa38,
Did this solution work for you? If it’s working, kindly mark it as the solution.

[yosiasz]

What does it show when you click the Table View button?

You need to specify time metric and value for it to work well in grafana
is Src_Name your metric for the rssi value?

please provide some sample data as csv here like

rssi,time,Src_Name
-33.5,2025-04-29 14:25:23.825030+00:00,289803572

or provide a script for generating your data

src/script/python/sqlite_ddl_dml.py

[kroa38]

Hello yosiasz,

Thanks you it works !

i have change my queries as you mention and added override for each serie.
i can now differentiate each series.

[yosiasz]

You don’t need overrides and that is not a dynamic solution, what if you have 100 nodes.

Make the result not time series but table Format then
Use matrix grouping transformation then convert time to time format