https://community.dynatrace.com/t5/DQL/Issue-with-dt-host-availability/m-p/303760#M3466 <P class="">With missing data, the value is returned as null. It could be that the most recent minute has not been fully processed or ingested yet, which makes the last datapoint appear missing. Default: 0 would the put it as 0.</P><P>Using to: -1m could help here by excluding the most recent, potentially incomplete minute from the query.</P> Tue, 25 Aug 2026 11:58:51 GMT michiel_otten 2026-08-25T11:58:51Z https://community.dynatrace.com/t5/DQL/Issue-with-dt-host-availability/m-p/303752#M3465 <P>Can someone explain why does this DQL query return Host Unavailable for any host every 5 minutes?</P><P>If we change the interval to another value, it seems to return host_unavailable at multiples of that interval.</P><P>The condition appears to be true for roughly one minute within each interval.</P><LI-CODE lang="markup">timeseries values = avg(dt.host.availability, default: 0), by: { dt.entity.host, dt.entity.host_group }, filter: { matchesPhrase(entityName(dt.entity.host), "example") }, interval: 5m, from: -15m | fieldsAdd host_availability = arrayLast(values) | filter host_availability == 0 | summarize affected_items = count() | filter affected_items &gt; 0 | fieldsAdd failed_condition = "HOST_UNAVAILABLE"</LI-CODE><P>&nbsp;</P> Tue, 25 Aug 2026 09:41:02 GMT https://community.dynatrace.com/t5/DQL/Issue-with-dt-host-availability/m-p/303752#M3465 JoãoSilva 2026-08-25T09:41:02Z https://community.dynatrace.com/t5/DQL/Issue-with-dt-host-availability/m-p/303760#M3466 <P class="">With missing data, the value is returned as null. It could be that the most recent minute has not been fully processed or ingested yet, which makes the last datapoint appear missing. Default: 0 would the put it as 0.</P><P>Using to: -1m could help here by excluding the most recent, potentially incomplete minute from the query.</P> Tue, 25 Aug 2026 11:58:51 GMT https://community.dynatrace.com/t5/DQL/Issue-with-dt-host-availability/m-p/303760#M3466 michiel_otten 2026-08-25T11:58:51Z