topic Re: Variables of specific Type in Dashboarding

Variables of specific Type

r_weber — Tue, 05 Dec 2023 11:12:26 GMT

Is there a way to specify a dashboard variable of type "duration"?
Or a way to convert a string to a duration within the makeTimeseries command, like this?

Aggregation = 1d,7d,30d

fetch logs, scanLimitGBytes: 5000 | filter isNotNull(k8s.deployment.name) | filter loglevel == "INFO" | fields k8s.deployment.name, chars=stringLength(content), timestamp | makeTimeseries sum_content_chars=sum(chars), by: {k8s.deployment.name}, interval:asDuration($Aggregation)

The above DQL fails with "Execution failed with error: failure to statically evaluate expression"

Re: Variables of specific Type

zietho — Thu, 07 Dec 2023 14:51:11 GMT

E.g. with duration(toLong($resolution), unit:"m"))}

FInd an example here: https://docs.dynatrace.com/docs/shortlink/dashboard-component-variable#limitations-when-using-variables-in-tiles

Re: Variables of specific Type

r_weber — Thu, 07 Dec 2023 17:11:12 GMT

I tried that before in this form:

... | makeTimeseries sum_content_chars=sum(chars), by: {k8s.deployment.name}, interval:duration(toLong($Aggregation),unit:d)

However this didn't work:
"The parameter `interval` has to be constant, but `duration(toLong("1"), d)` accesses data."

Re: Variables of specific Type

zietho — Thu, 07 Dec 2023 23:12:36 GMT

odd seems like there have been some changes.

What works for me is the following, where I just pass the unit as a second parameter:

timeseries avg(dt.host.cpu.idle), interval: duration(toLong("2"),"d")

Re: Variables of specific Type

r_weber — Fri, 08 Dec 2023 09:12:23 GMT

*Facepalm*...unit has to be a string!

| makeTimeseries sum_content_chars=sum(chars), by: {k8s.deployment.name}, interval:duration(toLong($Aggregation),unit:"d")

That works, also if the unit itself is a variable

Re: Variables of specific Type

zietho — Sat, 09 Dec 2023 07:16:30 GMT

Totally missed the quotation marks! Well cool then I am happy it works for you! Keep us in the loop when you face other issues! Always on the lookout for variable feedback.