Hi All!
I need to use Grafana for simple db queries to show some basic ERP data.
My MS SQL query is very simple:
select "Production Line", "Pallets" from vLiveProduction order by Plant, "Production Line"
The data are pretty straight forward and they display in a table.
I cant make them display in a graph or bar or any plugin i tried to. I must be doing something foundamentally wrong here but i cant see what. Any help?
I AM choosing series in graph but nothing changes. I cant find a way to tell grafana which column is the series and which the value… Tried by naming my columns metric and value but still no luck
