Table Chart Comparison & Running

Comparison Calculations

You can include metrics that compare the overall value of a column to each row of your data.

1. In Columns section, click the pen icon

1. Click on the down arrow in the Comparison calculation field to select the type of comparison calculation you want to use

2. Percent:total - the current row's value divided by the total for that field.

3. Percent:max - the current row's value divided by the maximum value for that field.

4. Diff:total - the total for that field minus the current row's value.

5. Diff:max - the current row's value minus the maximum value for that field.

6. Percent-diff:total - the total for that field minus the current row's value divided by the total for that field.

7. Percent-diff:max - the current row's value minus the maximum value for that field divided by the total for that field.

Another quick way to turn on the running calculations box is click the icon near the header of the table chart

Running calculations

Running computations produce a set of summary outcomes based on a set of data. They produce a result for each row of input, indicating how that row relates to the rest of the collection.

1. In Columns section, click the pen icon

2. Click on the down arrow in the Running calculation field to select the type of comparison calculation you want to use

• Running sum: sum all value from current row up

• Running min: minimum value from current row up

• Running max: maximum value from current row up

• Running count: current row value

• Running average: average value from current row up

• Running delta: value of current row - value of the row above

Another quick way to turn on the running calculations box is click the icon near the header of the table chart