Dynamic Aggregation

We combine the power of Tableau Parameters and visible columns in SuperTables. By doing this we will automatically remove / add detail from the datasheet which results in a different level of aggregation. With this incredible feature you only query the data you are looking at, and Table Calculations / LOD calculations will also keep working like you expect! On top of that you benefit from a performance boost!

Set up Dynamic Aggregation

Enter the configuration screen of SuperTables and head to the Appearance tab. Under Layout Options tick ‘Enable auto aggregation based on the visible columns in the table’

Our example:

1. Create a string parameter with the exact same name as your column. For example: ‘Category’ 2. Create a calculated field with the same name as the parameter in step 1. 3. Use this calculation: IIF([parameter_name] = ‘true’, [name_of_the_dimension], ‘_’) 4. Check if the parameter updates when you show/hide the column. In this example the column ‘Category’.

Next create a parameter of type ‘string’ with the current value ‘true’ as next we will be creating a calculated field. Follow our GIF to set up the calculated field.

Parameter:

Calculated Field:

All done, reload the extension to implement the dynamic aggregation to your SuperTable!