Skip to main content

Charts

Charts are the building blocks of a dashboard. They are live — they update automatically as the underlying data changes. Over 20 chart types are available, from bar and donut charts to treemaps, packed bubbles, and text tables.

Who configures this

Users with access to the New module. The Chart Builder is accessible from New > Custom Fields & Configuration > Chart Builder.

Chart list

Opening the Chart Builder displays the Chart Editor — a list of all charts in the organisation. Each chart is shown as a tile with its name. Click Create New Chart to start a new chart, or click any existing tile to edit it.

Chart Editor list showing existing charts and the Create New Chart tile

Chart Editor list

Chart Builder

Selecting a chart opens the Chart Builder. The interface has three panels: the DATA panel (left), the shelf and preview area (centre), and the FORMAT panel (right).

Chart Builder showing the DATA panel, shelf area, chart preview, and FORMAT panel

Chart Builder

DATA panel

The left panel is where you connect a datasource and browse the available fields.

FieldDescription
Chart NameThe name of the chart.
DatasourceThe virtual datasource the chart draws from. Datasources are created in the Query Builder. Click the eye icon to view the datasource definition.
Search fieldsFilters the list of dimensions and measures by name. Appears once a datasource is selected.
DimensionsText and date fields from the datasource. Drag these onto the shelves to group and categorise data.
MeasuresNumeric fields and aggregations (e.g. Count). Drag these onto the shelves to calculate values.

Shelf area

The centre-top section contains the shelves that control how fields map to the chart. The Role pill shows the active chart type. The available shelves change depending on the chart type selected in the SHOW ME panel.

ShelfChart typesDescription
X AxisBar, Line, Area, and similarThe dimension used to group data along the horizontal axis.
Y ValuesBar, Line, Area, and similarThe measure(s) plotted on the vertical axis. Supports aggregations (sum, avg, count, etc.).
ColorMost typesA field used to colour-code series or segments.
DetailMost typesA field that adds granularity without creating a separate series.
LabelMost typesA field whose values appear as chart labels.
TooltipMost typesA field shown in hover tooltips.
Label/SeriesRadarThe dimension that defines each axis on the radar.
ValueRadarThe measure plotted on each axis, with an aggregation selector (sum, avg, count, etc.).
ColumnsData GridThe fields displayed as columns in the table.

Chart preview

The centre area shows a live preview of the chart as fields are added to the shelves. A status bar above the preview displays the chart name, chart type, and a Live badge confirming the preview is connected to real data.

FORMAT panel

The right panel contains the chart type selector and formatting options.

SHOW ME

A grid of 23 chart type tiles. Clicking a tile switches the chart type immediately. The selected type is highlighted. Types recommended for the current field combination show a dot indicator. Types that require more fields than are currently placed are greyed out.

Chart typeDescription
BarVertical or horizontal bars grouped by a dimension.
DonutCircular chart showing proportional segments.
LineTrend line across a continuous dimension.
XYScatter-style plot with explicit X and Y fields.
HeatmapGrid of colour-coded cells showing value intensity.
RadarMulti-axis polygon chart for comparing across categories.
TimelineGantt-style chart for date-ranged items.
Data GridTabular view of data with sorting, filtering, and action rules.
GanttProject-style bar chart for scheduling and duration.
RelationNode-link diagram for showing relationships between records.
MarkdownFree-text panel rendered as formatted markdown.
TabsContainer that displays multiple charts in tab panels.
GaugeDial showing a single value against a target range.
BulletCompact bar with target and performance zones.
StatSingle large metric value with optional comparison.
ScatterPoint chart showing the distribution of two measures.
AreaFilled line chart showing cumulative or stacked values.
HistogramFrequency distribution across equal-width bins.
Box & WhiskerStatistical summary showing median, quartiles, and outliers.
TreemapHierarchical data shown as sized, nested rectangles.
Packed BubblesValues shown as area-proportional circles with grouping.
Circle ViewBubble layout with colour encoding and grouping.
Text TableCrosstab table with cell colouring and totals.

SETTINGS

Formatting options that vary by chart type.

Common options (most chart types):

OptionDescription
LayoutHow multiple series are arranged (e.g. Grouped or Stacked).
Corner radiusRounds the corners of bars. Range: 0–14 px.
Slice labelsShows value or percentage labels on slices or segments. Options: None, Value, %.
SortSort order for grouped results: High → Low, Low → High, or Data order.
LevelsNumber of concentric rings on a Radar chart. Range: 3–10.
PaletteThe colour scheme applied to the chart. Options: Docwize, Warm, Cool, Muted, Ocean, Earth, Vivid, Amber, Tide, Slate, Spectrum, Custom.

Data Grid options:

OptionDescription
Colouring RulesApply background or text colour to cells based on conditions.
Formatting RulesFormat cell values (e.g. decimal places, date format).
Action RulesAdd buttons to rows that trigger a named action (e.g. open a linked chart or interface).
Drilldown RulesDefine what a row click navigates to.
Editing RulesAllow users to edit specific fields inline.
Document Action SettingsMap columns to document ID, workflow ID, and other action parameters for row-level document actions.
Data layer settingsPin or hide specific columns.

INTERACTIONS

Click interactions that fire when a user selects a data point on the chart. Use these to drill down to a related record or open a linked interface.

How to create a chart

StepDescription
1Navigate to New > Custom Fields & Configuration > Chart Builder.
2Click Create New Chart.
3Enter a Chart Name and select a Datasource from the dropdown.
4Drag fields from Dimensions or Measures in the DATA panel onto the shelves in the centre area.
5In the SHOW ME panel, select a chart type. Compatible types for the current fields are highlighted.
6Adjust formatting options in the SETTINGS section as needed.
7Click Preview Chart to review the output, then Save Chart.

Troubleshooting

IssueDetail
No datasources availableA virtual view must exist before a chart can be created. Create one in the Query Builder first.
Chart type is greyed outThe selected type requires more fields than are currently placed on the shelves. Add the necessary dimensions or measures first.
Preview shows "No results"The datasource contains no data matching the current fields and filters. Check that the datasource has data and that all required filter values are set.
Chart shows no data after switching typeSome chart types require specific shelf configurations. Check which shelves the new type requires and place the appropriate fields.
  • Query Builder — creates the virtual views (datasources) that charts draw from
  • Dashboards — end-user instructions for viewing and using dashboards