Skip to main content
All CollectionsVisualizing Data
Select columns using control cells
Select columns using control cells

This canvas provides 2 options on how to add columns to filters in a control cell.

M
Written by Mitra Abrahams
Updated over 3 weeks ago

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

Did this answer your question?