Control cells allow you to dynamically select and filter your data, making analysis more flexible and efficient. This guide will walk you through a workaround for how to set up and use control cells for column selection and filtering.
Step 1: Add a control cell
First, add a single select control cell, choose the static option and within options input your column headerse
Option 1: Union the data
With this option, you can use a SQL cell to union the data, allowing you to add boolean_type
to the filter and apply it directly within the SQL query.
Option 2: Using a case when statement
With this option, you can use a CASE WHEN statement with the filter applied, ensuring that the SQL updates automatically based on the selected filter.
β
Final output:
Canvas link with more information : https://count.co/canvas/l2IhyYC8dr1