topic Last value from timeseries in DQL

Last value from timeseries

sinisa_zubic — Thu, 01 Jun 2023 08:32:23 GMT

Hi,

When using the timeseries command with the goal of displaying a single value (on the single value visualization), what is the best/preferred DQL syntax?

Best,
Sini

Re: Last value from timeseries

educampver — Thu, 01 Jun 2023 10:56:07 GMT

Hi Sinisa, you can use the arrayLast function. Here's an example of a query doing just that:

timeseries avg(dt.host.memory.usage) | fields arraylast(`avg(dt.host.memory.usage)`)