Count
count.co
  • Getting Started
    • What is Count?
    • Count FAQ
    • Intro to your workspace
    • Example canvases
    • Getting started guides
      • Set up your workspace and projects
        • 1. Review workspace settings
        • 2. Create and organise your projects
      • Canvas orientation
      • Your first ad hoc analysis
        • 1. Examples and templates
        • 2. Build your first queries
        • 3. Create visuals
        • 4. Caching, local cells and scheduling
        • 5. Collaborating with a stakeholder
      • Your first report
        • 1. Examples and templates
        • 2. Filters and control cells
        • 3. Sharing your report
        • 4. Alerts
  • Connect your data
    • Database connection overview
      • Athena
      • Azure Synapse
      • BigQuery
      • Databricks
      • Microsoft SQL Server
      • MySQL
      • PostgreSQL
      • Redshift
      • Snowflake
    • Refresh database schema
    • Upload CSV files
    • dbt integration
      • ☁️dbt Cloud integration
      • 👩‍💻dbt Core integration
  • Import & Export
    • Import from other tools
      • Import Miro files
      • Import SQL files
      • Import Google Sheets
      • Import Jupyter notebooks
    • Export code and results
      • Export compiled SQL and Jinja-SQL
      • Export CSV files
      • Export images and PDF files
  • THE CANVAS
    • Navigating the canvas
      • Canvas tool bar
      • Data sidebar
      • Customizing the canvas
    • Canvas objects
      • Cells
      • Text and markdown
      • Shapes and tools
      • Sticky notes
      • Frames
      • Images
      • Embeds
      • Stamps
      • Grouping objects
      • Object order and alignment
      • Locking objects
      • Scaling objects
      • Shared styles
    • Overviews
    • Templates
    • Count AI
    • Alerts and subscriptions
      • Slack integration
    • Keyboard shortcuts
  • Querying data
    • Cells overview
      • Dynamic query compilation engine
    • SQL cells
      • Referencing other cells
      • Jinja templating
      • SQL formatting
    • Python cells
    • Visual and low-code cells
      • Calculations in visuals and low-code cells
      • Joins in visuals and low-code cells
    • Control cells
      • Single and multiple selects
      • Date controls
      • Text, number, and boolean controls
      • Custom control cells
    • Local DuckDB cells
      • DuckDB on the server
    • Query caching and scheduling
    • Manage queries and results
    • Troubleshooting
  • Visualizing data
    • Visualization overview
    • Templated visuals
    • Custom visuals
      • Marks
      • Facet
      • Subplots
      • Style
      • Filters
    • Formatting a visual
      • Axes
        • Secondary Axis
      • Colors and labels
      • Legends
      • Tooltips
    • Column summaries
    • Dynamic text
    • Every Visual Under the Sun
  • Presenting and Reporting
    • Reports and Slides
  • Count Metrics
    • Intro to Count Metrics
    • Build and edit a catalog
    • Views
      • Creating views
      • Customizing views
    • Datasets
      • Creating datasets
    • Save changes to the catalog
      • Catalog validation
      • Version control
    • Exposing catalogs to the workspace
    • Caching in Count Metrics
    • Using the catalog
      • Explore from cell
  • Sharing and Permissions
    • Real-time collaboration
    • Comments
    • Sharing permissions
    • Shared links
    • Embedding canvases
  • History and Versions
    • Version control
    • Duplicating and merging
    • Data snapshots
  • Settings and administration
    • Workspace settings
      • Workspace members
      • Groups
      • Tags
      • Billing
      • Single sign-on (SSO)
        • Okta
        • Entra ID
        • JumpCloud
        • Google
        • Generic OIDC
      • Brand
    • Connection settings
    • Project settings
    • User settings
    • Roles and permissions
  • Quick guides
    • Interactive control guides
      • Date ranges
      • Date groupings
      • Search
      • Select All
  • Resources
    • Join the Slack community
  • Blog
  • Security overview
  • Terms of use
  • Pricing FAQ
Powered by GitBook
On this page
  • Introduction
  • What are interactive controls?
  • How to add an interactive control
  • How to connect to your queries
  • Allow users to change control cells
  1. Querying data

Control cells

Designed to give more power to your audience

PreviousJoins in visuals and low-code cellsNextSingle and multiple selects

Last updated 2 months ago

Introduction

The Count canvas is built for more than just static reports. Adding controls to your canvas transforms them into interactive reports and documents.

What are interactive controls?

Interactive controls are special cells that enable readers to interact with a shared canvas. Each control produces a table of one or more values that your readers can edit, that can be referenced just like any other cell.

You can create the following types of interactive controls:

  • - a number input

  • - a slider input to select a value

  • - an on/off field

  • - a free-form text entry field

  • - a date selection

  • - a drop-down to allow selection of a single element of a column (max 1,000 results)

  • - a drop-down to allow selection of multiple elements from a column (max 1,000 results).

  • Table filter - a field to add filters to a table

How to add an interactive control

Use the to insert control cells:

How to connect to your queries

There are a few things to know about control cells in order to connect them to your queries:

Control cells are tables

Inject them anywhere in your SQL

As control cells are just tables, you can add them into your WHERE statements to filter values, into the logic of a new column, or any other way you can think of!

Customize control cell appearance

When you think about how you want others to interact with control cells, you can customize:

  • the title (or prompt) the user sees

  • where the control cell is located

  • the options available

  • the default values selected

  • the font and format of the control

Allow users to change control cells

Control cells will behave differently depending on whether a user has edit or view access to a canvas, and whether the canvas is locked or unlocked.

The table below summarizes how these two states interact:

🔐 / Access
Canvas Editor
Canvas Viewer

Unlocked canvas

✅ Can edit control cells 👁 Edits are visible to everyone

❌ Cannot edit control cells 👁 Can see edits to control cells made by editors

Locked canvas

✅ Can edit control cells 🙈 Can only see their own edits

✅ Can edit control cells 🙈 Can only see their own edits

In summary, if you want a canvas to act like a typical dashboard or notebook where many users are using filters independently then make sure you lock the canvas, but if you intend to use the canvas as a collaborative space, then keep the canvas unlocked and invite contributors to be editors.

Read more about how locking affects canvases here:

Control cells have one column called value that contains the current value of the control cell. When referred to as tables, this column can be referenced in SQL. When referred to using , the value of the control cell is exposed directly.

You can either refer to control cells using pure SQL, or using templates.

Users of Redshift may encounter errors when referencing control cells using SQL - see this .

Number input
Slider input
Toggle input
String input
Date picker
Single select
Multiple select
canvas toolbar
Jinja
Jinja
Real-time collaboration
limitation and workaround
Reference control cells using their name