- Type: Inserted as a column
- Description: Calculates the average of all values in each column.
- Range:
- Columns: Each column
- Rows: All rows
- Measures: First measure
- Syntax:
avg(0, all, m1)
- Sample crosstab:
Example
In the table above we want to calculate the average of the last column (in a column).
Adding the calculation, the table now looks like this:
This could be the table behind a visualization like this:
Comments
Please sign in to leave a comment.