The Count notebook is built for more than just static reports. Making your notebooks interactive transforms your notebook into a dynamic, reactive document.
Interactive controls are special cells that enable readers to interact with a published notebook. 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:
Text input - a free-form text entry field.
Number input - an input which only allows numbers.
Date picker - a control which allows selection of a single day.
Single select - a drop-down to allow selection of a single element of a column (max 1,000 results).
Multiple select - a drop-down to allow selection of multiple elements from a column (max 1,000 results).
To add a control cell click the 'Add block' button, select 'Control', and then the type of control cell.
For Text inputs, Number inputs, and Date pickers, there's nothing else to do.
For single and multiple select controls, you'll need to select a column from your data tables or other cells to select values from:
Once you've added an interactive control to your notebook, you can feed it into your queries
A control is very similar to other cells. It has:
A title (optional)
A single output column called
So to add the control to the logic of your query you can reference it like any other cell. You can use arbitrary SQL logic to manipulate the value from the control cell, and controls cells appear everywhere else you see cells, such as the cells list in the data bar, and the dependencies are displayed in the structure tab.
Interactive controls allow your notebook readers to interact with the notebook. When the notebook is published, for each control cell:
The description and name are hidden
The control value defaults to the same value as it had in draft mode
When a reader changes the value of a control cell, that value is not saved