Single avg value instead full timeseries

[stefan_eggersto]

I'd like to display one single value (the average of all the value of the chart) instead of a timeseries.

When I choose "Single Value" display, it seems to display the values of ALL hosts, instead of one average:

[educampver · Accepted solution]

Hi Stefan, the timeseries command produces an array of data points. If you need to aggregate these values, you can use one of the available array functions. In this case, it would be the arrayAvg function, like so:

timeseries cpu=avg(dt.host.cpu.usage), by:dt.entity.host
| fields cpu=arrayAvg(cpu), dt.entity.host