I want to create an alert using a template, where the different alert queries are repeated just with a value change.
SELECT last("calc_total_power") FROM "proxy_stats" WHERE ("proxy_id" = ~ /^$chargepoint$/) AND $timeFilter GROUP BY time($__interval) fill(none)
I would like to have as many alerts as values of the variable $chargepoint, but without having to create them manually.
Is that possible with the new Grafana alerts? Where should I define the value of the variables? Ideally, I would like to define them by doing a query.
I followed the official documentation
I am using Grafana v8.0.2 and a InfluxDB.