05 Dec 2025 03:48 PM
In DQL, how to filter only working hours in a timeseries? For example: requests count from 8h to 18h (desconsidering 19h to 7h)
05 Dec 2025 05:37 PM
For example, this is our DQL usecase where we need to apply this kind of filter....
timeseries count = sum(dt.service.request.count, filter: { ( in(dt.entity.service, classicEntitySelector("type(service),entityName.startsWith(\"service1-")"))) OR ( in(dt.entity.service, classicEntitySelector("type(service),entityName.startsWith(\"service2-")")))
OR ( in(dt.entity.service, classicEntitySelector("type(service),entityName.startsWith(\"service3-")"))) }), by: { dt.entity.service }, interval:1h//, from:"08:00", to:"20:00"
| fieldsAdd entityName(dt.entity.service)
| sort count desc