Alert doesnt work, configured correctly?

[juergen16]

Hi

Using Grafana 11.4 with clickhouse connected i have the following alert configured.

Just selecting the number of entries in one table (there are +100k entries in there).
If the treshold is above 1 it should trigger.

When im clicking “preview” it show no firing message.

What do i missing here?

[antonio]

welcome @juergen16

Check if you need to add any expressions (e.g Reduce expression) to perform some calculation or transformation on the queried data.

Queries and conditions | Grafana documentation