Bar Chart with flter

[luca10]

I’m using Grafana 8.0.4 version

I have an sql database like this one:

Data	Ora	Indir.Prim.	ID	Fabbr.	Nø	Valore	Unit…	Descrizione	Tipo	Modulo	Posiz.	Tariffa
01/07/2021	00:00:00	1	1112302	SVM	1	39060	kWh	energy accumulation positiv	instant.	0	0	0

I have the below sql code that is working fine on sql database:

select
newData,
max(Valore)
from master
WHERE ID=“1112302” and Descrizione=“energy accumulation positiv”
group by year (newData), month(newData)
order by year(newData), month (newData)

but I’m not able to plot this data with Bar Chart where I have a value for each year/month
How can I manage this code to work in Grafana ?
Is it possible to filter/change the graph changing the ID number from the panel tab ?

[mattabrams]

Hi @luca10

Can you share a screenshot of your query editor? And maybe your data as it appears in either the table panel? Or copy/paste the data from clicking inspect => data on the panel?

And what specific datasource are you using/querying?