Use table calculations to create ad hoc metrics to use in your visualizations.
Table calculations are similar to spreadsheet formulas. They are displayed as green columns in a data table, rather than blue columns (dimensions) or orange columns (measures).
You can use table calculations to perform mathematical, logical, text-based, and date-based calculations on the dimensions, measures, and other table calculations in your query.
Keep the following considerations in mind as you use table calculations:
- All of the fields that you use in your table calculations must be part of your initial query.
- Formulas must be in lowercase.
- Table calculations only operate over rows that are returned in your query. If there is a 500 row limit, the 501st row will not be considered.
- You must always use leading zeros for decimals less than 1. For example, 0.95 will work, but .95 will cause an error.
- Table calculations are automatically displayed in visualizations.
- You can sort table
calculations just as you would a dimension or measure, with the following
differences:
- Table calculations are created after the data is retrieved from your data sources, which means that when you sort a table calculation, you can only sort the data that is already displayed.
- If a table calculation applies to multiple rows in the same column, sorting the table calculation would change the results and is therefore disabled. For example, if a table calculation includes the offset() function, sorting the table calculation would change the row being referred to, which is not permitted.