Analytics includes pre-built Table Calculations you can select from the Custom Field editor.

To begin a new pre-built Table Calculation:

1. Navigate to Custom Fields > Custom Dimension > Table Calculation.

   

2. The table calculation editor will display.

   

3. Click the Custom expression menu 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.

   

    

4. Select an option from the list.

5. Enter the source field. This is the data in the table you want for this calculation to read.

   

6. Each pre-built calculation has a default format that you can change if you want.

   

7. 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