I am very new to Grafana, I have created a chart with one data source and the legend is shown correctly.
I then created another chart with 2 data sources and now the legend shows … Electric Electric … it should only show Electric once. It may be my query is wrong or is there something in Grafana I need to change ?
OR it maybe I use 2 separate queries for the graph, like this …
select json_extract( value, ‘$.Gas_reading’ ) as Gas, json_extract( value, ‘$.iso’) as time from DATABASE, json_tree( DATABASE.data, ‘$.IP15’ ) where type = ‘object’ and json_extract( value, ‘$.Gas_reading’ );
select json_extract( value, ‘$.Electricity_reading’ ) as Electicity, json_extract( value, ‘$.iso’) as time from DATABASE, json_tree( DATABASE.data, ‘$.IP22’ ) where type = ‘object’ and json_extract( value, ‘$.Electricity_reading’ );
Hi,
It is already set to Time series.
I am using a JSON SQlite databse and I do not seem to have your choices of queries shown above or do i need to add or change something ?
You shouldn’t have to add an “override” but just use the regular “display name” setting.
This works pretty well in my opinion.
Version 3.1.1 of the plugin will have a bit better naming here but the core issue of more information added to the legend is due to Grafana (especially if using multiple lines in a chart).