Dashboards
A dashboard is an application showing live numbers and charts computed from your tables.
Create a dashboard
- Sidebar → + New → Dashboard and name it.
- Click Add widget and choose:
- Summary – one number, such as a count, sum, average, min, max, median or the number of empty rows.
- Chart – bar, line or pie chart of one or more series grouped by a field (for example revenue per month or deals per stage).
- Configure the widget in the right panel: pick the database, table and optionally a view (its filters are applied), the field and the aggregation.
Charts
- Series: each series is an aggregation (e.g.
sumofAmount). Add several to compare values. - Group by: the field used for the X axis or pie slices. Date fields can be grouped by day, week, month or year.
- Sort by the group value or the series value.
- Use a view to limit the data, for example to this year or to Status = Won.
Layout
Drag widgets to reorder them and resize them to one, two or three columns. Rename a widget by clicking its title and add a description for context.
Sharing
Everyone in the workspace who can access the dashboard sees the same live data. To share results outside the workspace, create a report in a project and publish it.
With an agent
Agents can create widgets using create_dashboard_widget and list them with
list_dashboard_widgets. Ask for example: “Create a chart of the sum of
Amount per Stage from the Deals table on the Sales dashboard.” See the
dashboard tutorial.