avg() Function Operation:

The avg() function has specific implementation and operational considerations, outlined below:

  • When a field doesn't exist on an event, or if the field on an event isn't a number, or when it is NaN the value will not be counted towards the average. So null values should not dilute the computed average.