Get the average of of a given timeperiod like "Office Hours"

Hello,

Kinda new with the whole Flux language and still learning. We got a request in which a user asked if it’s possible to filter out “non-officehour” datapoint.

We get datapoints 7x24 for our servers. The idea is to filter out everything which isn’t in the timerange between 7am - 6pm and weekends, then get the average of these values over a month.

Is something like this possible with Flux?

Hello @arcadesolutions,
Yes that’s possible.
Try using the hourselection function https://docs.influxdata.com/influxdb/v2.0/reference/flux/stdlib/built-in/transformations/hourselection/
Then you can apply the mean() function.