Stay organized with collections
Save and categorize content based on your preferences.
The AVG function calculates the average value of a numeric field.
Syntax
AVG(X)
Parameters
X - a field or expression that evaluates to an unaggregated number.
How the AVG function works
The AVG function takes 1 parameter, which must be the name of a numeric field, or a numeric expression. AVG returns the average for all values of that field or expression.
You can't apply this function to a pre-aggregated field (Aggregation equals Auto), or to an expression which is the result of another aggregation function. For example, a formula such as AVG(SUM(x)) will produce an error.
Examples
In these examples, the parameters passed to AVG are unaggregated numeric dimensions (i.e., they have an Aggregation type of None ).
Example formula
Input
Output
AVG(Latency)
0.02
0.07
0.09
0.06
AVG(CASE WHEN My Dimension < 1 THEN.5 WHEN My Dimension >= 1 AND My Dimension < 5 THEN 1 ELSE 2 END)
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-22 UTC."],[],[],null,["# AVG\n\nThe `AVG` function calculates the average value of a numeric field.\n\nSyntax\n------\n\n`AVG(`\u003cvar translate=\"no\"\u003eX\u003c/var\u003e`)`\n\n### Parameters\n\n- \u003cvar translate=\"no\"\u003eX\u003c/var\u003e - a field or expression that evaluates to an unaggregated number.\n\nHow the `AVG` function works\n----------------------------\n\nThe `AVG` function takes 1 parameter, which must be the name of a numeric field, or a numeric expression. `AVG` returns the average for all values of that field or expression.\n\nYou can't apply this function to a pre-aggregated field (Aggregation equals `Auto`), or to an expression which is the result of another aggregation function. For example, a formula such as `AVG(SUM(x))` will produce an error.\n| **Note:** This function can be applied in one of the following ways:\n|\n| - In a data source, change a field's Aggregation to `Average`.\n| - In a report, [edit the field's aggregation](/looker/docs/studio/edit-fields-in-your-reports) in a chart.\n\nExamples\n--------\n\nIn these examples, the parameters passed to `AVG` are unaggregated numeric dimensions (i.e., they have an **Aggregation** type of **None** ).\n\nRelated resources\n-----------------\n\n- [Calculated fields](/looker/docs/studio/about-calculated-fields)\n- [Looker Studio function list](/looker/docs/studio/function-list)"]]
