Skip to content

Configure charts and metrics

Charts explain a breakdown or trend. Metrics show one summary value. Use both when a dashboard needs an at-a-glance result and the context behind it.

Agency team members who build reporting dashboards or operational summaries. Requires View Layouts and Edit Layouts.

  • Create a view and add a section. See Create a view.
  • Decide whether the result needs a category breakdown, a trend, or one summary value.
  • Identify the data source, calculation, grouping field, and filters that define the result.
  1. Open the view in the builder from Settings, then Views ( /settings/views (opens in new tab) ).
  2. Drag a chart from Data into a section. Available chart blocks are Bar, Line, Pie, Donut, Area, and Scatter Plot.
  3. Select the chart and expand General.
  4. Enter Chart Title, confirm Chart Type, and choose Data Source.
  5. Expand Data.
  6. Under Data Series, select Add Series when the chart needs another calculation or subset.
  7. Choose Group By (Categories) for the category axis.
  8. Configure Sort Order, Data Limit, filters, and optional date filtering.
  9. Under Style, configure chart height, palette, legend, labels, stacking, axes, and number formatting as needed.
  10. Select Save Draft.
Bar Chart Data properties with Add Series, Group By, date filtering, sort order, data limit, and filter builder
View full size

For a count by status, use a count series and group by the status field. For a trend, use a line or area chart with an appropriate date grouping.

  1. Drag a metric from Data into a section. Available metric blocks are Count, Sum, Average, Percentage, and Custom Metric.
  2. Select the metric and expand General.
  3. Enter Metric Title.
  4. Choose Data Source.
  5. Choose Calculation Type and any field required by that calculation.
  6. Add filters to define which records contribute to the value.
  7. Configure Date Filtering when the metric should follow the view picker.
  8. Turn on Apply additional calculation only when the base result needs a static adjustment or second metric.
  9. Select Save Draft.
Count Metric properties with Clients as the data source, Count Records calculation, relationship aggregate, filters, and date filtering
View full size

A useful operational dashboard often follows this order:

  1. Metrics for the most important totals or rates.
  2. One or two charts that explain the breakdown.
  3. A filtered table or Kanban board for the underlying records.

Keep each block focused. A metric named Overdue tasks should filter to overdue tasks; a chart named Tasks by stage should group tasks by the stage field.

  • Charts render the selected calculation grouped and sorted as configured.
  • Metrics show one value calculated from the matching records.
  • Dashboard blocks that follow the view picker update for its selected date range.
SymptomLikely causeWhat to do
Chart has no categoriesGroup By (Categories) is emptyChoose a grouping field
Chart or metric is emptyData source, filters, or required calculation field is incompleteReview General and Data from top to bottom
Metric is unexpectedly highFilters are too broadAdd conditions that match the metric title
Dashboard date picker changes some blocks onlyOther blocks do not follow the picker or lack a date fieldConfigure Date Filtering on each intended block
Labels are hard to readChart style does not fit the dataAdjust height, label rotation, legend, data limit, or chart type