Selective Aggregation
Last updated
Last updated
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:
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).
Set the Column as a Dimension: Configure this column as a dimension in Tableau, and set its data type to "String".
Open SuperTables Configuration: Navigate to the SuperTables configuration settings.
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.
Set Aggregation Type: For the measure you want to aggregate, choose the "Selective Aggregation" option under the aggregation type.
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.
