AVERAGE returns the minimum value in a numeric dataset.
Function category: Statistical
AVERAGE can take an arbitrary number of additional arguments.
Can be a number, string or an array of numbers or strings (or anything that can be coerced into being a number)
Optional. Same restrictions as
Example 1: Find the average of the highest and lowest rated performance
Let's say we're given the following response with some driver performance information.
If we want to find the mean average of the highest and lowest rated driver performance, we would use the following function.
This would return the following:
AVERAGE can also take arrays as arguments.
AVERAGE(data.driver_performance_ratings.highest, data.driver_performance_ratings.lowest, data.driver_performance_ratings.fleet ) => 60.333