Description

Calculates the average of a set of numbers

Example

Find the average number of sessions for all your oracle instances

avg(instance[databasetype = 'oracle']/total_session_count)
avg(instance[databasetype = 'oracle']/total_session_count, 2)

Syntax

avg(expression)
avg(expression, precision)

Parameters

Type Description
Expresssion Expression that gives a set of numbers
Number Optional argument specifying the number of decimals in the result