How to Apply Average Function as a Calculated Average Function in Looker |

in this video we will create this a table and then we are going to apply or use the average function as a calculated field in our charts or tables from scratch so that you can get the awareness that when where and how we can apply the average function using calculated field
And before we use this function, let's understand the average function first.
So this AVG function in looker calculates the average value of a numeric field.
Now in this function we have two parts
Syntax → AVG(value)
Parameters value - it takes a field or expression that evaluates to an unaggregated number.
So The AVG function takes 1 parameter, which must be the name of a numeric field, or a numeric expression. And it returns the average for all values of that field or expression.
You can't apply this function to a pre-aggregated field which means that the Aggregation is equals to 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.
If you want to be become an Data Analyst or Business Analyst who has a great Excel Skill then you can follow the below link
Excel Playlist:-bit.ly/3rd9cEH
If you want to become an Data Analyst or Business Analyst who has a brilliant SQL Skills then you can follow the below link
SQL Playlist:- bit.ly/3v28GKY
If you want to become an excellent Data visualization Analyst then you can follow the below link
Google Data Studio playlist:- bit.ly/3v7czyc