Table calculations

Table calculations are a special type of transformation available in the Logic tab. They calculate values relative to the table, pane, or cell after data has already been aggregated in your visual.

Calculation types

Currently, the following calculations are supported:

1. Percent of total – Express each value as a percentage of the total, based on the chosen context.

2. Percentile – Assigns each value its percentile rank within the chosen context.

3. Rank – Assigns each value its rank (1 = lowest/highest depending on sort direction) within the chosen context.

Context options

The Context setting defines the scope over which the calculation runs:

1. Table – Uses the entire table (all rows and columns together).

2. Table (down) – Runs down each column. Each column is calculated independently.

3. Table (across) – Runs across each row. Each row is calculated independently.

4. Pane – Uses only the current pane (for visualizations with facets, each pane is calculated independently).

5. Pane (down) – Like Table (down), but scoped only to the current pane.

6. Pane (across) – Like Table (across), but scoped only to the current pane.

7. Cell – Uses only the value of the individual cell (for Percent of total this is always 100%).

Direction options

For Percentile and Rank, you can also choose a Direction:

• Ascending – Smallest value = lowest rank/percentile.

• Descending – Largest value = lowest rank/percentile.