# Find out request count per node vs total request count

**URL:** <https://community.dynatrace.com/t/find-out-request-count-per-node-vs-total-request-count/56649>\
**Category:** DQL\
**Tags:** dql, notebooks\
**Created:** [August 5, 2026, 10:14pm UTC](https://community.dynatrace.com/t/find-out-request-count-per-node-vs-total-request-count/56649 "2026-08-05T22:14:15Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![susmita\_k](https://avatars.discourse-cdn.com/v4/letter/s/7993a0/32.png) [@susmita\_k](https://community.dynatrace.com/u/susmita_k)\
**Post date:** [August 5, 2026, 10:14pm UTC](https://community.dynatrace.com/t/find-out-request-count-per-node-vs-total-request-count/56649/1 "2026-08-05T22:14:15Z")

</div>

Hi,

I need to set up an alert when the distribution of a particular request is not even across the different nodes. To do that, I need to find out the percentage of load based on the load/per node vs total load.&nbsp; I am trying to achieve it by this DQL, however the sum is not working. Any help is really appreciated.

fetch spans, from: now()-1h  
| filter service.name == “service-name”  
| summarize requests = count(), by: {host.name}  
| fieldsAdd total = sum(requests)  
| fieldsAdd pct = round(toDouble(requests) / toDouble(total) \* 100, 2)  
| sort requests desc

---

<div class="post-metadata">

**Author:** ![sujit\_k\_singh](https://avatars.discourse-cdn.com/v4/letter/s/34f0e0/32.png) [@sujit\_k\_singh](https://community.dynatrace.com/u/sujit_k_singh)\
**Post date:** [August 5, 2026, 11:26pm UTC](https://community.dynatrace.com/t/find-out-request-count-per-node-vs-total-request-count/56649/2 "2026-08-05T23:26:53Z")

</div>

Hi&nbsp;[@susmita\_k](https://community.dynatrace.com/user/67050)

Try this

fetch spans, from: now()-1h  
| filter service.name == “easytrade-ld-offerservice”  
| summarize requests = count(), by: {host.name}  
| summarize { total = sum(requests), d = collectArray(record(host.name, requests)) }  
| expand d  
| fieldsAdd host.name = d[host.name], requests = d[requests]  
| fieldsAdd pct = concat(toString(round(toDouble(requests) / toDouble(total) \* 100)), “%”)  
| fields host.name, requests, total, pct  
| sort requests desc

 ![sujit_k_singh_1-1785972064180.png](https://global.discourse-cdn.com/dynatrace/original/2X/e/e2070efbbf2fdbdd8cfb30a1611d13c7ff8bfd7a.png)

---

<div class="post-metadata">

**Author:** ![susmita\_k](https://avatars.discourse-cdn.com/v4/letter/s/7993a0/32.png) [@susmita\_k](https://community.dynatrace.com/u/susmita_k)\
**Post date:** [August 7, 2026, 1:02pm UTC](https://community.dynatrace.com/t/find-out-request-count-per-node-vs-total-request-count/56649/3 "2026-08-07T13:02:27Z")

</div>

Thank you&nbsp;[@sujit\_k\_singh](https://community.dynatrace.com/user/67382)&nbsp;. this works.

---

<div class="post-metadata">

**Author:** ![susmita\_k](https://avatars.discourse-cdn.com/v4/letter/s/7993a0/32.png) [@susmita\_k](https://community.dynatrace.com/u/susmita_k)\
**Post date:** [August 7, 2026, 1:06pm UTC](https://community.dynatrace.com/t/find-out-request-count-per-node-vs-total-request-count/56649/4 "2026-08-07T13:06:29Z")

</div>

[@sujit\_k\_singh](https://community.dynatrace.com/user/67382)&nbsp;can I make it a timeseries if I want to set up an alert in anomaly detection?

---

<div class="post-metadata">

**Author:** ![sujit\_k\_singh](https://avatars.discourse-cdn.com/v4/letter/s/34f0e0/32.png) [@sujit\_k\_singh](https://community.dynatrace.com/u/sujit_k_singh)\
**Post date:** [August 8, 2026, 6:04am UTC](https://community.dynatrace.com/t/find-out-request-count-per-node-vs-total-request-count/56649/5 "2026-08-08T06:04:50Z")

</div>

Hi&nbsp;[@susmita\_k](https://community.dynatrace.com/user/67050)

Try this if it works…

This will render as a timeseries line chart (one line per host) that you can use directly in Anomaly Detection.

fetch spans, from: now()-2h  
| filter service.name == “your-service-name”  
| makeTimeseries requests = count(), by: {host.name}, interval: 5m

 ![sujit_k_singh_0-1786168424723.png](https://global.discourse-cdn.com/dynatrace/original/3X/b/8/b82117f5380ca6b33a0def3cb60b14c479cfc391.png)

Time-bucketed data for anomaly detection alerting:

fetch spans, from: now()-2h  
| filter service.name == “your-service-name”  
| summarize requests = count(), by: {host.name, timebin = bin(start\_time, 5m)}  
| lookup [  
fetch spans, from: now()-2h  
| filter service.name == “your-service-name”  
| summarize totalRequests = count(), by: {timebin = bin(start\_time, 5m)}  
], sourceField: timebin, lookupField: timebin, fields: {totalRequests}  
| fieldsAdd pct = round(toDouble(requests) / toDouble(totalRequests) \* 100.0, decimals: 0)  
| fields timebin, host.name, requests, totalRequests, pct  
| sort timebin desc

 ![sujit_k_singh_1-1786168519868.png](https://global.discourse-cdn.com/dynatrace/original/2X/0/06208b6a634e8375169197f4ccb3c1bc8480f510.png)

Thanks,

Sujit

---

<div class="post-metadata">

**Author:** ![susmita\_k](https://avatars.discourse-cdn.com/v4/letter/s/7993a0/32.png) [@susmita\_k](https://community.dynatrace.com/u/susmita_k)\
**Post date:** [August 10, 2026, 3:59pm UTC](https://community.dynatrace.com/t/find-out-request-count-per-node-vs-total-request-count/56649/6 "2026-08-10T15:59:52Z")

</div>

Thanks much, I will try and let you know 🙂
