Setting up Selective Aggregation

In SuperTables you can use selective aggregation to aggregate only certain rows based on a condition. Selective aggregation instead of aggregating over all rows in a group, it aggregates based only on rows where a column has valid values, by using a flag system that can be setup by the user to determine valid values. 1 for valid values and 0 for invalid values.

To set up selective aggregation in SuperTables, follow these instructions:

1. Prepare Your Worksheet: Ensure your worksheet contains atleast one column with values (e.g., 1s for rows to aggregate and 0s for rows to leave unaggregated).

2. Set the Column as a Dimension: Configure this column as a dimension in Tableau, and set its data type to "String".

3. Open SuperTables Configuration: Navigate to the SuperTables configuration settings.

4. Assign the Aggregation Flag Column: Select the column you want to apply selective aggregation to, and set the "Column Flag" to the column with 1s and 0s.

5. Set Aggregation Type: For the measure you want to aggregate, choose the "Selective Aggregation" option under the aggregation type.

6. Apply to Multiple Columns: Repeat the steps for multiple columns if needed, following the same process.

The video below explains the whole process for 1 column but selective aggregation can be used with multiple columns.

8MB

Tableau.mp4