Widgets

Widgets let you add interactive inputs directly inside Python cells. These widgets allow users to filter, tweak, and parameterize downstream queries and logic without writing code.

The Querio AI agent can automatically generate and use these widgets to build dynamic, reusable reports for your team.

Available Widgets

You can use a variety of widgets to parameterize your analysis:

• Date Pickers: Select single dates or date ranges to filter time-series data.
• Multi-select Dropdowns: Choose multiple categories or tags from a list.
• Single-select Dropdowns: Pick exactly one option from a predefined list.
• Text Inputs: Provide free-form text search or filtering criteria.
• Number Inputs: Specify numeric thresholds, limits, or configuration values.
• Radio Buttons: Select a single option from a small set of mutually exclusive choices.
• Sliders: Adjust numeric values interactively.

How They Work

Widgets are rendered from Python cells. When a user interacts with a widget (e.g., selects a new date or chooses a different option from a dropdown), the updated value becomes available to the rest of the notebook.

Any downstream SQL or Python cells that depend on this value will automatically react and re-execute, updating charts, tables, and metrics in real time.

Try it out in the embedded example below:

Using Widgets with the AI Agent

You don't have to write the code for these widgets yourself. You can simply ask the AI agent to make your report dynamic.

For example, you can say:

• "Add a date picker so I can filter the revenue chart by month."
• "Create a multi-select dropdown for the region column."
• "Add a slider to let me adjust the churn probability threshold."

The AI agent understands widgets natively and will write the necessary Python code to embed them into your notebook and link them to your downstream queries.