Dashboard

A Dashboard page shows a high-level view of your data. It uses widgets on a flexible grid. Other layouts connect to one table, but a dashboard page does not. Each widget connects to its own table or view. Thus, one dashboard can summarize data from all of the base.

Dashboard page

Arranging widgets

While you edit, drag widgets to move them. To change their size on the 12-column grid of the page, use the resize handles. To configure a widget, click it. Its settings open in the properties panel.

You can put widgets in groups. A group header has a title, which wraps across lines when necessary. It can also have an optional rich-text description that viewers see.

A group header can also have buttons. These buttons can open a record creation form for the table of the group, go to a page or external URL, or run an automation.

Adding widgets

Click Add widget and select a widget from the palette:

Add widget

WidgetDescription
Static textHeadings, paragraphs and rich notes. Supports formatting, alignment and callout tints.
DividerSeparates sections visually.
NumberOne headline metric: a record count or a field aggregation (sum, average, min, max). Appearance options include default, filled and colored themes.
Bar ChartCompares values across categories.
Line ChartShows trends over a sequence.
Pie ChartShows the share of a whole for each category.
Donut ChartShows the share of a whole, with a center cutout.
TreemapShows proportions as tiles of different sizes.
Scatter PlotShows the correlation of two numeric fields.
GaugeShows the progress of a metric against colored ranges.
PivotSummarizes records across two fields, with rows, columns and totals.
ViewEmbeds a full visualization (Grid, Gallery, Kanban, List, Calendar or Timeline) in the dashboard.
iFrameEmbeds an external page by URL.
The availability of some widgets depends on your workspace's plan. Widgets not included in your plan show an upgrade badge in the palette.

Configuring widgets

Widgets that show data have the same configuration steps in the properties panel:

SettingWhat it sets
Data sourceThe table or view that the widget reads from. You can also add filters for the widget.
ValueA record count or a field aggregation (sum, average, min, max).
AppearanceTheme colors, legends and labels.

Chart settings

Chart data

Bar, line and scatter charts show data on two axes:

AxisSettings
X-axisThe field on the axis, its sort order and a category limit. You can also set if empty values get their own category, and if NocoDB combines the remaining categories into an "Others" category. An optional legend title is also the axis caption.
Y-axis (left)One or more fields, each with its own aggregation and color. Add fields to show more than one series on the same axis. You can set an axis label. Use Start at zero to start the axis at zero.
Y-axis (right)Turn on Show this axis to show one more series against a secondary axis on the right. This series has its own field, aggregation, color, Start at zero setting and Type: Bar, Line or Scatter. When you mix types, a line can show over bars, for example.

A chart with a secondary Y-axis configured

Pie, donut and treemap charts do not use axes. You configure Categories and one Values entry: a record count or a field aggregation.

Chart appearance

SettingWhat it does
Bar orientationShows bar charts horizontally or vertically.
Legend orientationLeft, right, top, bottom or hidden. NocoDB offers a legend when it adds information: always for pie and donut charts, and for other charts when they show more than one series. Show record count in legend adds counts to legend entries.
Smooth lines and Plot dots on linesAppearance toggles for line series.
Show values on chart (bar, line, scatter, treemap) or Show percentage on chart (pie, donut)Shows each value directly on the chart.
SizeSmall, Medium or Large.

The Gauge widget uses a metric and a set of ranges. Each range has its own color, minimum, maximum and label.

Charts are interactive: users can click a chart segment to see the underlying records.

Last updated on

Latest product updates?See Changelog
Stay in the loop? Follow us onLinkedInLinkedInYouTubeYouTubeXX