he i have problem with the email alert with the task i dont know how to choose the value that i want
`import “http”
import “json”
import “influxdata/influxdb/secrets”
option task = {
name: “2”,
every: 1s,
}
MAILJET_APIKEY = “mykey”
MAILJET_SECRET_APIKEY = “mykey”
numberOfCrits = from(bucket: “solo”)
|> range(start: -task.every)
|> filter(fn: (r) => r.measurement == “statuses” and “r.level” == “crit”)
|> count()
numberOfCrits
|> map(
fn: (r) => if r._host1 < 0 then
{r with
_value: http.post(
url: “https://api.mailjet.com/v3.1/send”,
headers: {
“Content-type”: “application/json”,
“Authorization”: “Basic ${MAILJET_APIKEY}:${MAILJET_SECRET_APIKEY}”,
},
data: json.encode(
v: {
“Messages”: [
{“From”: {“Email”: “uchiha_moath@hotmail.com”}, “To”: [
{“Email”: “uchihamoath@gmail.com”},
], “Subject”: “InfluxDB critical alert”, “TextPart”: “There have been ${r._value} critical statuses.”, “HTMLPart”: “
${r._value} critical statuses
There have been ${r._value} critical statuses.”},
],
},
),
),
}
else
{r with _value: 0},
)`
i dont know how to make it for the value spo2 below so if the value bigger then 0 will sent an email
