I’ve been trying to create alerts depending on the time of day, and came across this workaround:
- Add the following query to your metric:
hour(), that returns the hour of the day (0-23). You can make it hidden in the graph.
- Add an extra
ANDcondition to your alert, so it’s only alerting if the
hour()query is between the range you want (eg: office hours).
How could I create a metric “hour” that returns[0…23] depending on the hour of day?(I didn’t ask on the issue not to pollute people’s mailbox who subscribed to it)
Grafana 7.0 InfluxDB 1.7.10