I am using Kapacitor batchnode for flux query. I want to extract the min value of all values i get and basically raise alert based on some condition. Following is the tickscript i wrote:
var data = batch
|queryFlux('''
from(bucket: "bucket")
|> range(start: -60m)
|> filter(fn: (r) => r["_measurement"] == "measurement")
|> filter(fn: (r) => r["_field"] == "_field" and r["_value"] > 0)
|> keep(columns: ["tag1","_time","_value","_field"])
|> last()
''')
.every(1h)
|min('_value')
var alert = data
|alert()
.crit(lambda: "_value" >= 0)
.message('Testing alert')
.log('/tmp/alerts.log')
However, i am not able to get any logs even after condition being satisfied. Can someone help me here.