Hello.
Currently I'm trying to create graphs that show some metrics with avg, max and min values. 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 to turn data collection off, but I need that data: I just want the data from non-business hours to not be processed when getting averages. Example: get average ISP's bandwidth utilization during business hours for 6 months (daily usage). I still need non-business period's data (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.
Currently I'm trying to create graphs that show some metrics with avg, max and min values. 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 to turn data collection off, but I need that data: I just want the data from non-business hours to not be processed when getting averages. Example: get average ISP's bandwidth utilization during business hours for 6 months (daily usage). I still need non-business period's data (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.