DQL
Questions about Dynatrace Query Language
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

DQL interval - Filtering working hours

helton_harada
Contributor

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

1 REPLY 1

helton_harada
Contributor

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

Featured Posts