Last value from timeseries

[sinisa_zubic]

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

[educampver · Accepted solution]

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)`)