cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Single avg value instead full timeseries

stefan_eggersto
Dynatrace Mentor
Dynatrace Mentor
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:
 
 
 
stefan_eggersto_2-1685542229153.png

 

 

1 REPLY 1

educampver
Dynatrace Helper
Dynatrace Helper

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

 

 

Featured Posts