# Dynatrace alert created by Davis Anomaly Detection is not triggering with the given DQL

**URL:** <https://community.dynatrace.com/t/dynatrace-alert-created-by-davis-anomaly-detection-is-not-triggering-with-the-given-dql/56140>\
**Category:** DQL\
**Tags:** dql, anomaly-detection\
**Created:** [June 10, 2026, 3:25pm UTC](https://community.dynatrace.com/t/dynatrace-alert-created-by-davis-anomaly-detection-is-not-triggering-with-the-given-dql/56140 "2026-06-10T15:25:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ravi\_singh](https://avatars.discourse-cdn.com/v4/letter/r/94ad74/32.png) [@ravi\_singh](https://community.dynatrace.com/u/ravi_singh)\
**Post date:** [June 10, 2026, 3:25pm UTC](https://community.dynatrace.com/t/dynatrace-alert-created-by-davis-anomaly-detection-is-not-triggering-with-the-given-dql/56140/1 "2026-06-10T15:25:21Z")

</div>

PROBLEM STATEMENT:-  
I m using the below query for creating an alert using davis anomaly detetcor, my alert configs are:-  
threshold: 2  
sliding window - 5  
violating samples - 1  
dealerting samples - 3

So this is showing correct data in notebook but davis alert not triggering,

can someone HELPPPPPPPPPPPPPPPPP?

DQL:-

```markup
timeseries cpu = avg(process.cpu.time),
by: { `host.name`, `process.executable.name` },
filter: startsWith(`host.name`, "t")
and in(`process.executable.name`,
{"process_1", "process_2", "process_3", "process_4", "process_5"})
| fieldsAdd avg_cpu = arrayAvg(cpu)
| fieldsAdd proc_status = if(isNotNull(avg_cpu) and avg_cpu > 0, "UP", else: "DOWN")
| summarize {
process_1_status = takeAny(if(`process.executable.name` == "process_1", proc_status)),
process_2_status = takeAny(if(`process.executable.name` == "process_2", proc_status)),
process_3_status = takeAny(if(`process.executable.name` == "process_3", proc_status)),
process_4_status = takeAny(if(`process.executable.name` == "process_4", proc_status)),
process_5_status = takeAny(if(`process.executable.name` == "process_5", proc_status))
}, by: { `host.name` }
| fieldsAdd
process_1_status = coalesce(process_1_status, "DOWN"),
process_2_status = coalesce(process_2_status, "DOWN"),
process_3_status = coalesce(process_3_status, "DOWN"),
process_4_status = coalesce(process_4_status, "DOWN"),
process_5_status = coalesce(process_5_status, "DOWN")
| fieldsAdd process_status = concat(
"process_1 (description 1): ", process_1_status,
" | process_2 (description 2): ", process_2_status,
" | process_3 (description 3): ", process_3_status,
" | process_4 (description 4): ", process_4_status,
" | process_5 (description 5): ", process_5_status
)
| fieldsAdd terminal_availability = if(
process_1_status == "DOWN"
or process_2_status == "DOWN"
or process_3_status == "DOWN"
or process_4_status == "DOWN"
or process_5_status == "DOWN",
0,
else: 1
)
| fieldsAdd terminal_status = if(terminal_availability == 0, "TERMINAL_DOWN", else: "TERMINAL_UP")
| fieldsAdd hostName = `host.name`, timestamp = now()
| makeTimeseries terminal_availability = avg(terminal_availability),
by: { hostName, process_status, terminal_status },
time: timestamp,
interval: 1m

```

---

<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:** [June 10, 2026, 10:09pm UTC](https://community.dynatrace.com/t/dynatrace-alert-created-by-davis-anomaly-detection-is-not-triggering-with-the-given-dql/56140/2 "2026-06-10T22:09:47Z")

</div>

Hi&nbsp;[@ravi\_singh](https://community.dynatrace.com/user/96953)

The issue is a mismatch between your output values and threshold configuration.

The Root Cause  
Your final makeTimeseries produces terminal\_availability = avg(terminal\_availability) which can only ever output 0 or 1:

terminal\_availability = if(  
process\_1\_status == “DOWN”  
or process\_2\_status == “DOWN”  
…  
0,  
else: 1  
)  
But your threshold is set to 2.

Since your metric never reaches 2 (max is 1), the threshold is never breached — so alert never fires.

Set your threshold to 1 with the condition “below” (alert when terminal\_availability \< 1). When any process goes DOWN, the value drops to 0, crosses below your threshold, and alert fires.

Thanks,

Sujit

---

<div class="post-metadata">

**Author:** ![ravi\_singh](https://avatars.discourse-cdn.com/v4/letter/r/94ad74/32.png) [@ravi\_singh](https://community.dynatrace.com/u/ravi_singh)\
**Post date:** [June 11, 2026, 12:16pm UTC](https://community.dynatrace.com/t/dynatrace-alert-created-by-davis-anomaly-detection-is-not-triggering-with-the-given-dql/56140/3 "2026-06-11T12:16:38Z")

</div>

Hi sujeet , actually i have put the threhold for testing pupose as all processes were up&nbsp;  
so termina\_avaiability = 1 \< 2 (threshold), so it can trigger the alert, forgot to mention this earlier, thanks for your response.

---

<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:** [June 12, 2026, 12:10am UTC](https://community.dynatrace.com/t/dynatrace-alert-created-by-davis-anomaly-detection-is-not-triggering-with-the-given-dql/56140/4 "2026-06-12T00:10:15Z")

</div>

Hi&nbsp;[@ravi\_singh](https://community.dynatrace.com/user/96953)

Thanks for clarifying — that makes sense. If you’re using a “below” condition with threshold 2, then the value of 1 should indeed breach it.

In that case, the issue could be your time: timestamp field in the final makeTimeseries:

| fieldsAdd hostName = `host.name`, _timestamp = now(_)

Using timestamp = now() forces all data into a single timestamp rather than producing a continuous time-series

Try this:&nbsp;Remove the timestamp = now() and also&nbsp;&nbsp;drop process\_status and terminal\_status from the by: clause — those string fields create unnecessary dimension explosion.

| makeTimeseries terminal\_availability = avg(terminal\_availability),  
by: { hostName },  
interval: 1m

Let me know if it works or seeing any issue.

Thanks,

Sujit
