Creating response time dashboard filtering using the tags

[karthikayini_m]

Hi All,

Trying to create dashboard in new dynatrace.(not classic).

Chose the variables as tree and then sub variable as tall and short

fetch dt.entity.service
| filter iAny(startsWith(tags[], "tree"))
| expand tags
| filter contains(toString(tags), "tree : tall") or contains(toString(tags), "tree :short ")
| parse tags, "ld:key ':' ld:Value"
| summarize collectDistinct(Value)

After this I am struggling to get the response time or latency for the above services tagged to tree .

Could some one help me to write dql getting response time for the filters tree and followed by tall and short.

I use dt.service.request.response_time for response metric

please suggest me the dql query

[Emm4nuel · Accepted solution]

Hi karthikayini_m,

You missed two things in your query, I’ve added a couple of options that might be considered advanced. Let me walk you through the final version to achieve what you’re aiming for:

timeseries response_time = avg(dt.service.request.response_time), by: { dt.entity.service }
| lookup [ 
    fetch dt.entity.service
], sourceField:dt.entity.service, lookupField:id, fields:{entity.name, tags}
| expand tags
| filter contains(toString(tags), "tree :short ") or contains(toString(tags), "tree :tall ")
| parse tags, "ld:key ':' ld:Value"

Explanation:

• Average Response Time: This line calculates the average response time. You need it to retrieve the actual metric—fetch alone won’t do that.
• Service Details: I used lookup to get extra info like service names and tags.
• Filtering: I applied your tag filters directly. I removed the | filter iAny(startsWith(tags[], "tree")) since it was redundant—you’re already filtering in the next step.

In short, I get the response time, enrich it with service details, and then apply the tag filters you wanted. Let me know if this works for you or if you have any questions!

[karthikayini_m]

Thank you @Emm4nuel

Dynatrace Helper