# Graph the number of requests to a service according to response time **URL:** \ **Category:** DQL\ **Tags:** dql, dashboards\ **Created:** [May 21, 2026, 8:47am UTC](https://community.dynatrace.com/t/graph-the-number-of-requests-to-a-service-according-to-response-time/55975 "2026-05-21T08:47:12Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![AlexLarrieu](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@AlexLarrieu](https://community.dynatrace.com/u/AlexLarrieu)\ **Post date:** [May 21, 2026, 8:47am UTC](https://community.dynatrace.com/t/graph-the-number-of-requests-to-a-service-according-to-response-time/55975/1 "2026-05-21T08:47:12Z")
Hello, Using DQL, I want to create a graph to display the number of requests for a specific service with a response time \> 10s. Similar to the Distributed Tracing app ( but not only Successful requests ). Could you help me? Alex ![AlexLarrieu_0-1779353005023.png](https://global.discourse-cdn.com/dynatrace/original/3X/e/4/e4d1805c23388282fddeed5f133ceb1b1e851662.png) ---
**Author:** ![krzysztof\_hoja](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/krzysztof_hoja/32/34625_2.png) [@krzysztof\_hoja](https://community.dynatrace.com/u/krzysztof_hoja)\ **Post date:** [June 8, 2026, 10:43am UTC](https://community.dynatrace.com/t/graph-the-number-of-requests-to-a-service-according-to-response-time/55975/2 "2026-06-08T10:43:28Z")
If you are interested how query looks like, you can refer to query id shown in the app: ![krzysztof_hoja_0-1780914481583.png](https://global.discourse-cdn.com/dynatrace/original/3X/0/b/0b158d0163cc4fd25909ee1a5fa11df2b1272761.png) and then check dt.system.query\_exections table for particular query id with: ```markup fetch dt.system.query_executions | filter query_id == "0b12de7e-2891-4acc-a335-1ae959a054c4" ``` ---
**Author:** ![Kenny\_Gillette](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/kenny_gillette/32/20170_2.png) [@Kenny\_Gillette](https://community.dynatrace.com/u/Kenny_Gillette)\ **Post date:** [June 8, 2026, 1:07pm UTC](https://community.dynatrace.com/t/graph-the-number-of-requests-to-a-service-according-to-response-time/55975/3 "2026-06-08T13:07:21Z")
Hi, This is possible.  Set filter you want to use in Distributed Trace.  Click 3 dots on right and click on “Edit in Notebook” or “Pin to Dashboard” ![Kenny_Gillette_0-1780921766863.png](https://global.discourse-cdn.com/dynatrace/original/3X/2/6/26f173a55573a21f56625102770a010b1702077a.png) Once there, click on Options then Line ![Kenny_Gillette_1-1780921958214.png](https://global.discourse-cdn.com/dynatrace/original/2X/7/75bd96582d2464a9352a4c099f983ffd1c2bf6b4.png) Click Run ![Kenny_Gillette_0-1780924010272.png](https://global.discourse-cdn.com/dynatrace/original/3X/5/6/56bdcda2b17040e2f69d96dbe4b287e959220cd1.png) Dynatrace Assist: Here’s a DQL query to display the  **number of requests per time interval for a specific service where response time \> 10s** , as a timeseries graph — covering all requests (not just successful ones): * * * ##### DQL Query — Requests with Response Time \> 10s (Timeseries) fetch spans, from: now() - 2h| filter request.is\_root\_span == true| filter duration \> 10s| filter dt.entity.service == “SERVICE-XXXXXXXXXXXXXXXX”| makeTimeseries requests = count(), interval: 1m > 🔁 Replace SERVICE-XXXXXXXXXXXXXXXX with your actual service entity ID. * * * ##### How to Use This in Distributed Tracing 1. Open the  **Distributed Tracing**  app 2. Click  **“Run DQL”**  or open a  **Notebook / Dashboard tile** 3. Paste the query above 4. Set the visualization to  **Bar chart**  or  **Line chart** * * * ##### Key Points Element Explanation | request.is\_root\_span == true | Counts only entry-point requests (like the Distributed Tracing app does), not internal/child spans | | --- | --- | | duration \> 10s | Filters spans with response time exceeding 10 seconds (10s is a valid DQL duration literal) | | No request.is\_failed filter | Includes  **both successful and failed**  requests | | makeTimeseries … count() | Produces a time-bucketed series suitable for a graph | | interval: 1m | Adjust granularity — use 5m, 10m, etc. for longer timeframes | * * * ##### Optional: Filter by Service Name Instead of ID If you prefer to filter by name rather than entity ID: fetch spans, from: now() - 2h| filter request.is\_root\_span == true| filter duration \> 10s| fieldsAdd service\_name = entityName(dt.entity.service)| filter service\_name == “your-service-name”| makeTimeseries requests = count(), interval: 1m * * * ##### Optional: Break Down by Service (All Services) To see all services with slow requests in one graph: fetch spans, from: now() - 2h| filter request.is\_root\_span == true| filter duration \> 10s| fieldsAdd service\_name = entityName(dt.entity.service)| makeTimeseries requests = count(), interval: 1m, by: { service\_name } ---
**Author:** ![krzysztof\_hoja](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/krzysztof_hoja/32/34625_2.png) [@krzysztof\_hoja](https://community.dynatrace.com/u/krzysztof_hoja)\ **Post date:** [June 8, 2026, 7:04pm UTC](https://community.dynatrace.com/t/graph-the-number-of-requests-to-a-service-according-to-response-time/55975/4 "2026-06-08T19:04:34Z")
It is also possible to do the same for top chart. I was not able initially to find “three dots” for top chart. When you hover the chart menu open in upper right corner and you can get it directly as in app ![krzysztof_hoja_1-1780945370206.png](https://global.discourse-cdn.com/dynatrace/original/1X/34a601e7052c4937c5f31d485cdb2becdc9ec4de.png) ---
**Author:** ![AlexLarrieu](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@AlexLarrieu](https://community.dynatrace.com/u/AlexLarrieu)\ **Post date:** [June 9, 2026, 9:41am UTC](https://community.dynatrace.com/t/graph-the-number-of-requests-to-a-service-according-to-response-time/55975/5 "2026-06-09T09:41:01Z")
Thanks to both of you, [@krzysztof\_hoja](https://community.dynatrace.com/user/25373)  and [@Kenny\_Gillette](https://community.dynatrace.com/user/36140) , that’s the result I was looking for. I now understand that the three dots don’t produce the same DQL query. [@Kenny\_Gillette](https://community.dynatrace.com/user/36140)  : I see you’re using Dynatrace Assist. I’ve tried it, but I’ve never managed to get a correct solution. What question did you ask the AI? ---
**Author:** ![Kenny\_Gillette](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/kenny_gillette/32/20170_2.png) [@Kenny\_Gillette](https://community.dynatrace.com/u/Kenny_Gillette)\ **Post date:** [June 9, 2026, 12:30pm UTC](https://community.dynatrace.com/t/graph-the-number-of-requests-to-a-service-according-to-response-time/55975/6 "2026-06-09T12:30:02Z")
Glad we could help you.  I copied your question exactly and put in DT assist ![Kenny_Gillette_0-1781008181256.png](https://global.discourse-cdn.com/dynatrace/original/3X/8/d/8d36f59f7d229bbb03a993b6f387ea55db18d505.png) ---
**Author:** ![AlexLarrieu](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@AlexLarrieu](https://community.dynatrace.com/u/AlexLarrieu)\ **Post date:** [June 10, 2026, 8:41am UTC](https://community.dynatrace.com/t/graph-the-number-of-requests-to-a-service-according-to-response-time/55975/7 "2026-06-10T08:41:10Z")
Thanks for the explanation. With the correct permissions for agentic AI, I get the same response.