Fix DQL makeTimeseries Error: Parameter Must Be an Expression

anujjain504 — Wed, 17 Dec 2025 12:40:14 GMT

SPL:
|chart values(Total) as Total by date_hour,TimeDiffFinal

DQL

| makeTimeseries Total=collectDistinct(Total), by:{date_hour, TimeDiffFinal}, time:LatestTime

So, basically i have converted values into collectDistinct in dynatrace.

Getting ERROR -The parameter has to be an expression-based timeseries aggregation.

Re: ERROR - makeTimeseries - "The parameter has to be an expression-based timeseries aggregation." - collectDistinct()

t_pawlak — Fri, 07 Nov 2025 14:34:13 GMT

Hi,
I think, that the error happens because makeTimeseries requires a numeric aggregation (e.g., countDistinct, sum, avg, last), while collectDistinct() returns a list, which can’t form a timeseries.

You can try with this:

fetch logs, scanLimitGBytes: -1 | summarize Total_list = collectDistinct(Total), by: { date_hour = bin(timestamp, 1h), TimeDiffFinal } | sort date_hour asc, TimeDiffFinal asc

You should recive table and list of values

topic Fix DQL makeTimeseries Error: Parameter Must Be an Expression in DQL

Fix DQL makeTimeseries Error: Parameter Must Be an Expression

Re: ERROR - makeTimeseries - "The parameter has to be an expression-based timeseries aggregation." - collectDistinct()