Data Explorer :: Filtering Metrics By Partial Service Name and Partial Request Name

[rmozone]

Hello!

I'm working with Dynatrace's Data Explorer in Advanced Mode and am trying to filter a specific metric, specifically `builtin:service.requestCount.total`, based on partial matches for both service name and request name. I'm looking for a way to achieve this using either glob patterns, regex, or any other method that allows for partial matching.

Could anyone provide guidance or examples on how to construct such a query?

Any help or pointers towards relevant documentation would be greatly appreciated!

Something like this:

builtin:service.requestCount.total
  :filter(
    and(
      in("dt.entity.service",entitySelector("type("SERVICE_METHOD"),entityName.in(~"/url1~",~"/url2")"))
    ))

Thank you!

[AntonPineiro]

Hi,

You can use contains:

builtin:service.requestCount.total
:filter(and(or(in("dt.entity.service",entitySelector("type(service),entityName.contains(~"XXXXX~")")),in("dt.entity.service",entitySelector("type(service),entityName.contains(~"YYYYY~")")))))
:splitBy("dt.entity.service")
:sort(value(auto,descending))

Best regards