Use makeTimeseries with fetch entity for Advanced DQL Time-Series Queries

FShimaya — Wed, 17 Dec 2025 12:07:56 GMT

I would like a DQL statement (either in Dashboard or Notebook) to perform the following query and result in an event so that query results are alertable depending on the threshold. In this case, I would like an event generated when DQL query results in a downtime value greater than 3600 seconds. Here is the statement:

fetch dt.entity.cloud_application_instance, from:now()-24h
| fieldsAdd entity.name, lifetime, downtime = unixSecondsFromTimestamp(now()) - unixSecondsFromTimestamp(lifetime[start])
| filter in(id, classicEntitySelector("type(CLOUD_APPLICATION_INSTANCE),toRelationships.IS_PG_OF_CAI(type(PROCESS_GROUP), tag(kpod))"))
| fieldsAdd duration(downtime, unit:"s"), alias:duration
| filterOut downtime < 3600
| makeTimeseries count(default: 0), spread: timeframe(from: lifetime[start], to: coalesce(lifetime[end], now())), by:{entity.name,duration}, interval: 1m
| limit 200| makeTimeseries count(default: 0), by:{entityName,isOffline,timestamp}, time:{timestamp}, interval: 1m

But when I run this query, I get the following error message:

Analyzer execution failed

DQL result data could not be treated as a timeseries. No valid time series records found. A valid time series record containsa single duration field, a single timeframe and one or multiple numeric arrays. Consider using the 'timeseries' or 'makeTimeseries' DQL command.

What do I need to do to fix this DQL statement ?

| filterOut downtime < 3600

Re: How to use makeTimeseries in conjunction with fetch entity command and AI Davis

IzabelaRokita — Wed, 17 Dec 2025 12:07:30 GMT

Hey @FShimaya ,
I just wanted to check in and see if you still need help with this. If so, I’d be happy to look into it for you! 😊
Please let me know what works best for you.

topic Use makeTimeseries with fetch entity for Advanced DQL Time-Series Queries in DQL

Use makeTimeseries with fetch entity for Advanced DQL Time-Series Queries

Re: How to use makeTimeseries in conjunction with fetch entity command and AI Davis