When I watch the video about creating a graph they select their database and then select their data items.
When I do the same I select my database and some programming stuff pops up and I cannot select my data variables.
Maybe I don’t have something installed?
I can pull up data with a table using “SELECT * from Item8”
using Grafana 5.3.2 on Ubuntu server with MySQL data server.
Maybe it is supposed to work like this and I am to the script. Grafana does give me an example, shown here.
SELECT
UNIX_TIMESTAMP(<time_column>) as time_sec,
<value column> as value,
<series name column> as metric
FROM <table name>
WHERE $__timeFilter(time_column)
ORDER BY <time_column> ASC
so I have to apply my settings approprately. And that’s the problem. I don’t know where to put what.
I have a running MySQL database full of data. My database is called “openhab” and my other data is labeled as shown below: