Analytics includes pre-built Table Calculations you can select from the Custom Field editor.
To begin a new pre-built Table Calculation:
Navigate to Custom Fields > Custom Dimension > Table Calculation.
The table calculation editor will display.
From the Calculation dropdown, select the Custom expression type to access the list of custom expression options.
By default, the Calculation type will be set for Custom expression. This means you can enter custom calculations.
- Select an option from the list.
Select the Source field from the dropdown. This is the data in the table you want the calculation to read.
Each pre-built calculation has a default format that you can modify if needed.
After selecting the calculation and source, click Save.
The Calculation will be pushed into your data.
The% of previous column compares the absolute value of a cell to the column to its left. For example:
- 9 is 82% of 11, 10
- 10 is 56% of 18
- 1 is 25% of 4
% change from previous column calculates the percentage change from previous to current. For example:
- 5 is a 44% drop from 9
- 9 is a 10% drop from 10
- 12 is 1,100% growth from 11
% of row sums values in complete row and calculates the percentage that each value makes up of that sum. For example, 4+18+10+9=41
- 4 is 10% of 41
- 18 is 44% of 41
- 10 is 24% of 41
- 9 is 22% of 41
The Running row total adds each value to the sum of previous values in a row:
- 4=4
- 4+18=22
- 4+18+10=32
- 4+18+10+9=41
% of column sums values in complete column and calculates the percentage that each value makes up of that sum. For example, 10+9+1+1=21
- 10 is 48% of 21
- 9 is 43% of 21
- 1 is 5% of 21
% of previous calculates the percentage of a value compared to the value below it. For example:
- 8 is 22% of 36
- 36 is 88% of 41
- 41 is 683% of 6
% change from previous calculates the percentage change from a value to the one below it. For example:
- 8 is a 78% decrease from 36
- 36 is a 12% decrease from 41
- 41 is a 583% increase from 6
Rank of column displays the position that each value ranks in relation to the others in the column. For example:
- 8 is the 5th largest value
- 36 is the 2nd largest value
- 41 is the largest value
Running total adds each value to the sum of previous values in the column. For example:
- 4=4
- 4+2=6
- 4+2+4=10