Filter from the SQL database I cant get it to work

Grafana MySQL
1

Hi All,

I am quite new to this so bring it to me gently :slight_smile:
I am using Grafana v8.0.5 on a pi and I have created a sql database on MariaDB that runs on a other PC. That all work its beeing filled at this moment.

SELECT
DateTime AS “time”,
CnlNum,
Val
FROM (table)
WHERE
$__timeFilter(DateTime) and
CnlNum = 201
ORDER BY DateTime

I can filter out in this case the 201

image
image1501×368 44.2 KB

But it gives only dots and the values are not corresponding with the X-as

Hope I explained myself a bit

Thanks beforehand!

2

This topic was automatically closed after 365 days. New replies are no longer allowed.