Show your data as a chart

Add a pie, bar, line or area chart that groups your records by a field and shows a count or a total for each group.

  • Verified Nov 17, 2026
  • Classic builder

On this page
  1. Add a chart
  2. Group the records and choose the values
  3. Chart options
  4. Limit which records are charted
  5. Design and PDF pages
  6. Check that it works

A Chart groups the records of a table by one field and draws a count or a total for each group, for example the number of jobs in each status. Use it on dashboards and reports.

Add a chart #

  1. Open the page In the Page Builder, open the page and its Content tab. Click the Components tab in the left panel.
  2. Add the Chart Under Data Components, click Chart or drag it into a column.
  3. Choose a chart type Under Choose a Chart Type, click Pie Chart, Bar Chart, Line Chart or Area Chart.
  4. Choose the records Answer Which records should this chart display? by selecting a table, or records connected to the page's record or to the logged-in user. See Choose which table and records a component shows.
  5. Set up the chart Click Customize. On the Chart tab, choose Group By and the calculation, as described below.
  6. Save Click Update & Close.

The settings window has four tabs: Data Source, Chart, Filters and Design.

Group the records and choose the values #

The Chart tab has a Data section and a calculation section.

SettingWhat it does
Group ByThe field whose values become the slices, bars or points, for example Status. Each distinct value is one group. A connection field groups by the connected record.
Group LabelThe name of the grouping shown on the chart, for example Status.
ByWhat each group measures. Total Number of records counts the records in the group. Picking a Number, Currency, Rating, Slider, Basic Formula, Complex Formula or Equation field adds up that field for the group (rounded to two decimals).
LabelThe name of the value, shown in the legend and tooltips. It is Total for a new chart.

Bar, line and area charts can show more than one value per group. Each value is a tab above the calculation; click Add New to add one, for example the count of jobs and the total of their invoices side by side. A pie chart has one value.

The Chart tab of a chart's settings with Group By set to Status and By set to Total Number of records

Chart options #

The Options section of the Chart tab changes how the chart looks.

OptionWhat it does
Chart TypeFor a pie chart: Pie Chart, Donut Chart or Semi-Circle Chart. For a bar chart: Bar Chart (horizontal bars) or Column (vertical bars).
StackedBar charts only. Stacks the values of a group in one bar instead of side by side.
Chart TitleA title shown on the chart.
Sort ByOrders the groups by the Group By field or by the value, ascending or descending.
LegendWhere the legend appears: Right, Bottom or None.
Between LineLine charts only. Hide removes the line that joins the points, leaving only the points.
DimensionAuto fits the chart to its column. Custom lets you set Chart Width, Chart Height and Legend Width in pixels (a new chart starts at 500 by 350).
ThemeThe color set: Default, Google, Soft, Bright, Gradient or Custom.

Limit which records are charted #

  • Data Source > Filters: click Add New Filter Group to chart only some records, for example jobs created this year. See Choose which records a component shows.
  • Filters: turn on Filter Tabs to show tabs above the chart, each with its own conditions, so people can switch between views such as This Month and Last Month. Hide Clear Filter Tab removes the tab that clears the filter.

Design and PDF pages #

The Design tab sets the component's fonts, background, border, spacing and CSS. See Change how your app looks.

Chart is also listed under Data Components in the PDF Page editor, so a chart can be part of a generated PDF. There it has no Filters tab. See PDF pages.

Check that it works #

Open the page in your live app. Each group shows its count or total. If the chart is empty, check the data source filters, the selected filter tab, and that the Group By field has values.

Was this page helpful?

Something wrong or missing on this page? Tell us.