Table Chart Comparison & Running
Last updated
Was this helpful?
Last updated
Was this helpful?
You can include metrics that compare the overall value of a column to each row of your data.
In Columns section, click the pen icon
Click on the down arrow in the Comparison calculation field to select the type of comparison calculation you want to use
Percent:total - the current row's value divided by the total for that field.
Percent:max - the current row's value divided by the maximum value for that field.
Diff:total - the total for that field minus the current row's value.
Diff:max - the current row's value minus the maximum value for that field.
Percent-diff:total - the total for that field minus the current row's value divided by the total for that field.
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 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.
In Columns section, click the pen icon
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
