Appearance
Grid page
Grid page is one of the notebook page types. It arranges charts and SQL run results defined on a doc page as a tile-based dashboard. You can place, reorder, resize, and drag and drop components.
Analysis (creating SQL and charts) is done on the doc page, and the grid page arranges them by reference. Even when you create a new chart from the grid page's right sidebar, the chart itself is created on the doc page side.
Key features
- Tile-based layout (drag and drop, resizing, mobile layout)
- Placing components from Components in the right sidebar (built-in elements, charts, query results)
- Grid settings (columns, row height, edit guide)
- Displaying parameters, placing them as tiles, and overriding parameters per placed component
- Explorer
- Cross filter
Available components
The components available on a grid page are grouped as follows. Place them from Components in the right sidebar.
Built-in
Elements specific to grid pages. Not shared with doc pages.
| Component | Description |
|---|---|
| Heading | A heading (Heading 1 / Heading 2 / Heading 3). You can also add a description. |
| Text | Places supplementary text. |
| Image | Upload and place an image. You can adjust its size and position. |
| Spacer | Blank space between components. You can also configure whether it's shown in the mobile layout. |
Parameters
Places the input form of a parameter as a tile. The Parameters section in the right sidebar lists defined parameters by scope (Notebook common / Page specific).
- The first two candidates in each scope are shown initially. Use Show (count) more to expand the remaining candidates.
- Place them by drag and drop, or with Add to the bottom. Parameters that are already placed show In use, and the same parameter can't be placed more than once.
- On the tile, you can enter a value and change the title (synced with the parameter's label).
- Edit settings such as the type and default value from the parameter form at the top of the page.
- Parameters referenced by SQL or charts on this page also appear in the parameter form at the top of the page. You can change their values from both the form and the tiles.
- If a parameter isn't referenced by SQL or charts on this page, the tile shows a message indicating that it isn't referenced instead of showing an input.
- If the referenced parameter definition is deleted, the tile shows a message that the parameter is unavailable. You can delete the tile in the editor.
From doc pages
Places SQL blocks and charts defined on a doc page by reference. In the right sidebar, candidates under the Chart section are listed by doc page name, then SQL block name.
You can search candidates by SQL block name or chart title. Select Filter next to the search field to see All, Query result, and available chart types. Select an item to show only candidates of that type.
| Component | Description |
|---|---|
| Chart | Places a chart created on a doc page. You can also create a new chart from an existing SQL block using New chart in the right sidebar. |
| Query result | Places the run result table of a doc page's SQL block. There's one candidate per SQL block. |
Each SQL block section always shows its query result and chart candidates. Select a candidate row to open a preview to the left of the right sidebar. To close the preview, select outside it, press Esc, or use its close button. To place a candidate, drag it by the grip or use the add button in its row to add it to the end of the grid.
If there are no SQL blocks or charts on the doc page side, no candidates are shown. Candidates that are already placed show In use.
For charts and SQL run results, you can configure parameter overrides and cross filter per component.
Grid settings
From Grid settings in the header, you can configure the grid granularity and the background guide shown while editing.
| Item | Description |
|---|---|
| Guide display | The background guide shown while editing. Choose from None / Dots / Grid lines. The default is Grid lines. |
| Columns | The number of columns the page is divided into horizontally. An integer from 1 to 60. The default is 12. |
| Row height (px) | The height of one vertical grid unit. An integer from 10 to 120. The default is 60. |
- Guide display takes effect as soon as you select it. It applies only to your own screen and doesn't affect other users.
- Columns and row height take effect when you change the values and select Apply. They're saved as page settings and apply to all users viewing the page.
- When you change the number of columns, placed components are converted to the new grid while keeping their width ratios as much as possible. Components that no longer fit side by side after reducing the number of columns are automatically stacked vertically.
- For the value ranges, see Limits.
Syncing chart settings
- Settings for the chart itself, such as axes and type, are synced with the doc page side. Even if the same chart is placed on multiple grids, its settings are shared.
- Display settings on the grid, such as header display and component titles, aren't synced.
- Parameter overrides and cross filter settings are also specific to each component on the grid.
- Chart settings aren't shared with other users until explicitly saved.