Grafana dont gets my data

Grafana Configuration
1

Hello everyone,

i created an Panel with my PostgresSQL Query.

image
image852×283 11.6 KB

The generated SQL:
image

But there is no data showing.

When i type the raw generated sql command in postgressql i get 3 sites of data.

Can somebody help me fix my problem?

The Type of “date” is a timestamp without time zone

Best regards

2

Try to add the WHERE using Macro: $__timeFilter

Regards,
Fadjar Tandabawana