2. Filters and control cells
Last updated
Last updated
Control cells can be used to filter the results you show. The types of available in Count range from field selectors, text/number inputs and date selectors.
When using control cells for reporting, there are 2 key points to note:
Setting up your control cells
Optimising canvas performance by making use of local cells
Control cells can be referenced from SQL queries, or linked directly into visuals/low code cells.
When selecting a control cell, the code snippet required to reference it is shown in the right-hand sidebar. Copy this snippet into your SQL code to reference the control.
Control cells can be referenced from filters in visual or low-code cells - select a filter, then select Connect to control. Count will generate the required SQL to reference the control cell automatically.
To make sure your report loads quickly you'll want to make use of local cells, caching and scheduling.
When using these features with respect to reporting, you want to consider when and where in your data modelling you switch to using local cells.
If you have control cells, you want everything from this point onwards to be local. This means you're not querying your database every time a filter is changed, resulting in much faster updates.
Insert our into your canvas for some further examples.
As discussed in an , local cells and caching are crucial when understanding how to increase the performance of your canvas. This is even more important when it comes to reports, as they tend to be read more widely.
Read about the full range of control cells .
If has been disabled for the canvas or any downstream cells, then you'll need to manually re-execute those cells if they depend on the control cell that was changed.
