InfluxDB business hours data only

Grafana InfluxDB
1

Hi,

I’m using Grafana 7.5 and my datasource is InfluxDB 1.8 filled by Icinga (Influx Query Language, not Flux).
For a SLA calculation I need to overlap timepicker with addition timeframes.
E.g. I set timepicker to “last 30 days” which shows me values 24x7. But I only want to display (and to calculate with) values that where created let’s say in business hours 08:00-17:00 on each of those 30 days?

Did anyone succeed to such a solution?

Thank you for your help & best regards
Uwe

2

I finally found a workaround by using Flux instead of Influx Query Language. That offers a function hourSelection e.g. “|> hourSelection(start: 8, stop: 17)”