Tick not firering and I don't understand why

1

Hi there I have the following very simple tick script :slight_smile:
# kapacitor show pg_max_connection
ID: pg_max_connection
Error:
Template:
Type: stream
Status: enabled
Executing: true
Created: 19 Jun 20 13:59 UTC
Modified: 19 Jun 20 14:03 UTC
LastEnabled: 19 Jun 20 14:03 UTC
Databases Retention Policies: [ā€œpgstatsā€.ā€œautogenā€]
TICKscript:
dbrp ā€œpgstatsā€.ā€œautogenā€

var data = stream
    |from()
        .measurement('pgstats_databases')
        .groupBy('cluster', 'account')

data
    |alert()
        // critique a  95%
        .crit(lambda: float("percent_connection_usage") > 25.0)
        // formatage du message
        .message('[Kapacitor Alert] {{ index .Tags "cluster" }} , {{ index .Tags "account" }}: Connexion usage is {{ index .Tags "`percent_connection_usage`" }}')
        .email()

DOT:
digraph pg_max_connection {
graph [throughput="1.00 points/s"];

stream0 [avg_exec_time_ns="0s" errors="0" working_cardinality="0" ];
stream0 -> from1 [processed="1012503"];

from1 [avg_exec_time_ns="7.681Āµs" errors="0" working_cardinality="0" ];
from1 -> alert2 [processed="1012503"];

alert2 [alerts_inhibited="0" alerts_triggered="0" avg_exec_time_ns="27.564Āµs" crits_triggered="0" errors="0" infos_triggered="0" oks_triggered="0" warns_triggered="0" working_cardinality="17" ];
}
/ #

When I look at my grafana, I have a bunch of ā€œpercent_connection_usageā€ that are aboce 25 and , the alert doesnā€™t fire.
What am I missing ? what is wrong with the way Iā€™ve written my alert ? Is there a way to debug this ?

Thanks
Ludo