topic Re: DQL interval - Filtering working hours in DQL

DQL interval - Filtering working hours

helton_harada — Fri, 05 Dec 2025 15:48:02 GMT

In DQL, how to filter only working hours in a timeseries? For example: requests count from 8h to 18h (desconsidering 19h to 7h)

Re: DQL interval - Filtering working hours

helton_harada — Fri, 05 Dec 2025 17:37:41 GMT

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

Re: DQL interval - Filtering working hours

Julius_Loman — Sun, 07 Dec 2025 20:34:18 GMT

A native DQL solution (I changed the filter not to use entity selector):

timeseries { requests = sum(dt.service.request.count), timestamp=start()} , by:{ dt.entity.service} , filter:{ startsWith(entityName(dt.entity.service), "service1") or startsWith(entityName(dt.entity.service), "service2") or startsWith(entityName(dt.entity.service), "service3") } , interval:1h | fieldsAdd dt.entity.service.name = entityName(dt.entity.service) | fieldsAdd requests=if(getDayOfWeek(timestamp[])<6, requests[]) | fieldsAdd requests=if(getHour(timestamp[],timezone:"Europe/Vienna")>=8, requests[]) | fieldsAdd requests=if(getHour(timestamp[],timezone:"Europe/Vienna")<=18, requests[]) | fieldsRemove timestamp

Re: DQL interval - Filtering working hours

helton_harada — Mon, 08 Dec 2025 12:58:56 GMT

Very Good @JuliusLoman !

It works! Thanks a lot for your help!