Hello.
Currently I’m trying to create graphs using Zabbix plugin as data source which show some metrics with avg, max and min values in legend. I want to exclude data from a periods outside of business hours (include only data from 09:00-18:00, Mon-Fri).
I know that I can use custom intervals or maintenance periods in Zabbix to turn data collection off, but I need that data: I just want the data from non-business hours to not be processed when using aggregation functions. Example: get average ISP’s bandwidth utilization during business hours for 6 months (daily usage). I still need non-business period’s data (maybe I’ll use it in other graph to see if there was some load at the night for example), but I don’t need it to be calculated in aggregation functions.
Grafana was a hope, as it gives you much more flexibility in data processing, but I didn’t find anything that could help. I thought that maybe I could use some data filtering by time field in transformation, but there was no luck as well.
Post on Zabbix forum:
https://www.zabbix.com/forum/zabbix-help/433534-exclude-unwanted-data-from-time-periods-in-dashboards-grafana