Skip to main content

Create charts

The chart editor is where collections become indicators. By dragging fields and choosing calculations, you can build in minutes a month-by-month closing chart, a site ranking, a shift comparison or a card with the year-to-date result. The editor suggests the most suitable chart type for each field, shows the result as you build it and lets you change the chart type at any time without losing what you have configured.

Each chart answers a question. Before you start, write that question in one sentence ("what is the average result of each site this year?"): it defines what goes on the horizontal axis, what goes on the vertical axis and whether you need to break it down by a category.


Open the editor​

There are three ways:

  • From a dashboard — with the dashboard in edit mode, click Add → Visualization. When you are done, Save and return places the chart in the dashboard.
  • From Discover — click a field in the list and then Visualize. The editor opens with a chart ready for that field.
  • From the library — in ☰ → Analytics → Visualize Library, click Create visualization.

Editor layout​

AreaWhere it isWhat it does
Field listLeft columnData source selector, field search and all available fields, grouped by type. Fields can be dragged onto the chart.
Chart areaCenterShows the chart while it is being built. At the top are the chart type selector, the search bar, the filters and the editor's time range.
Options toolbarAbove the chartAppearance, labels, legend and axis buttons. The buttons change according to the chart type. See Formatting and style.
SuggestionsBelow the chartReady-made variations of the current chart (other types, other combinations). Click a suggestion to apply it.
Configuration panelRight columnThe chart dimensions (for example, Horizontal axis, Vertical axis and Breakdown) and layers.

Your first chart​

A bar chart with the average result of each month:

  1. Open the editor and check, in the top left corner, that the data source is correct.
  2. In the chart type selector, choose Bar.
  3. In Horizontal axis, click Add or drag-and-drop a field and choose the date field (date). The Date histogram function is selected automatically. In Minimum interval, choose Month.
  4. In Vertical axis, choose the result field (for example, perc-total). Change the function to Average.
  5. In Name, type "Average result". In Value format, choose Number, with 1 decimal and the % suffix.
  6. In the editor's time range, choose the desired range, for example Last 1 year.
  7. Click Save and return (if you came from a dashboard) or Save, and give the chart a title.
Check the function chosen automatically

When you place a numeric field on the vertical axis, the editor usually chooses Median. If the indicator is an average, change it to Average. The difference can be large when there are few collections or very different values. See Average or median.


Chart dimensions​

Most charts have three dimensions:

DimensionOn screenWhat it receivesExample
Horizontal axisHorizontal axisA grouping: dates, categories or rangesMonths, sites, shifts
Vertical axisVertical axisOne or more metrics (calculations)Average result, number of collections
BreakdownBreakdownA grouping that splits each bar or lineStatus, region, defect type

In horizontal bar charts, the axes swap places on screen, but the logic is the same: categories go in one dimension and metrics in the other. Metric cards, gauges, tables and pie charts have dimensions with other names. See Chart types.

Click a dimension to open its options. Each dimension has two parts:

  • Function — the calculation or grouping (for example, Average, Top values).
  • Field — the field used by the function.

Groupings​

The grouping defines how collections are split on the horizontal axis or in the breakdown. There are four types:

GroupingOn screenGroups byExample
By dateDate histogramHour, day, week, month or yearMonth-by-month closing
Top valuesTop valuesThe values of a text fieldSite ranking
Number rangesIntervalsRanges of a numeric fieldTemperature or age bands
FiltersFiltersOne search bar expression per groupSplit forms, build a funnel

Date histogram​

OptionWhat it does
Minimum intervalThe size of each group: Auto, hour, day, week, month, year. With Auto, the size changes with the selected time range.
Customize time intervalAllows intervals such as 2 weeks or 3 months.
Include empty rowsShows intervals without collections (with zero or empty value), so the timeline doesn't skip months.
Drop partial intervalsHides the first and last intervals when they are incomplete (for example, the current half-finished month).
Fix the interval in closing charts

With Auto, the interval is recalculated every time the time range or a filter changes. In a dashboard filtered by a site with few collections, a monthly chart may start showing daily bars, thin and widely spaced. For closing charts, always choose the interval (for example, Month).

Top values​

OptionWhat it does
Number of valuesHow many values to show (for example, 10 sites). The default is usually 3 or 5: increase it when the list is longer.
Rank byThe sort criterion: one of the chart metrics, the number of collections or alphabetical order.
Rank directionDescending (highest to lowest) or Ascending (lowest to highest).
Group remaining values as "Other"Puts the values left out into an "Other" group. Turn it off for rankings.
Include documents without this fieldShows a group for collections where the field is empty.
Include values / Exclude valuesShows only some values or hides specific values (for example, a test site).
Rankings with few collections

A site with a single audit can appear in first place with 100%. For fair rankings, also show the number of collections (in a table or in the chart tooltip) or filter the time range so that every site has a minimum number of collections.

Intervals (number ranges)​

Groups a numeric field into ranges. There are two modes:

  • Automatic ranges — a slider sets the number of equally sized ranges. Useful to see the distribution of weights, times or scores (histogram).
  • Create custom ranges — you define each range and its label, for example:
FromToLabel
60Below 60
607060 to 70
708570 to 85
8585 or more

The "From" value is included in the range and the "To" value belongs to the next one.

A histogram also reveals typing errors

A histogram of weights or temperatures quickly shows unexpected values, such as negative weights or three-digit temperatures. These values are usually entry errors and distort averages and sums. Fix them at the source or filter them out in the chart.

Filters​

Each group is defined by a search bar expression and gets a label. It is the most flexible grouping: groups don't have to come from a single field.

UseExpressionLabel
Split forms_index : *site-a*Site A
Funnel stagestested : "Yes"Tested
Funnel stagesresult : "Positive"Positive
Funnel stagesreferred : "Yes"Referred
Groups of several categoriesshift : (Night or Overnight)Night period

Click Add a filter for each group. A collection that matches more than one expression is counted in each corresponding group.


Breakdowns​

The breakdown splits each bar, line or area by a category. Use it to compare the composition of each group: the status of audits at each site, the defect types of each month, the regions throughout the year.

  1. In Breakdown, choose the field (for example, status). The Top values function is selected automatically.
  2. Adjust Number of values to show every category.
  3. Turn off Group remaining values as "Other" if you don't want the "Other" group.

In bar and area charts, the breakdown can be displayed in three ways, chosen in the chart type selector:

ModeOn screenShows
StackedStackedThe total of each group and the share of each category.
Side by sideUnstackedEach category in its own bar, to compare values.
PercentagePercentageThe share of each category, with every bar adding up to 100%.
Why does my chart show 500%?

In Stacked mode, the category values are added to make the bar height. That makes sense for quantities, but not for averages and percentages: five sections at 100% each become a 500% bar. To compare averages or percentages, use Unstacked or a Line chart.

Few categories per chart

More than 6 or 7 colors in one chart make it hard to read. If the breakdown has many categories, limit it to the top values, use a line chart with only the most important categories or create a separate chart for the detail.


Several metrics in the same chart​

The vertical axis accepts more than one metric. Click Add or drag-and-drop a field below the first metric to add another. Each metric becomes a series, with its own color and name. Example: one line for each section of an audit (Sort, Set in order, Shine…), all with Average.

Same format to avoid two axes

When metrics have different formats (for example, one with the default format and another with the % suffix), the editor places each on its own vertical axis, left and right. To keep a single axis, use the same Value format in every metric, or set Axis side to Left in each.

Avoid combining several metrics with a breakdown in the same chart: each metric-category combination becomes a series, and the chart ends up with too many colors. To compare several metrics by category, a table is usually easier to read.


Layers​

A bar, line or area chart can have several layers, overlaid on the same axis. Click Add layer, below the dimensions, and choose the type:

Layer typeOn screenUse
ChartVisualizationAnother series, with another type or data source (for example, bars with total collections and a line with the average).
Reference lineReference linesTargets, limits and tolerances.
AnnotationAnnotationsMark dates on the chart (for example, a process change or a training).

Each layer has its own chart type, chosen in the icon next to its name.


Target line​

  1. In the editor, click Add layer → Reference lines.
  2. In Reference line value, choose Static value and type the target (for example, 70).
  3. Adjust the appearance:
    • Name — the line label, such as "Target 70%". In Text decoration, choose to show the name on the line.
    • Color — for example, red for a limit or gray for a target.
    • Line — thickness and style (solid, dashed or dotted).
    • Fill — shades the area above or below the line, useful to highlight the unacceptable range.
    • Axis — the line's axis, when the chart has two.
  4. For more than one reference (for example, minimum and maximum temperature limits), click Add or drag-and-drop a field in the same layer.
The target can also be calculated

Instead of a fixed value, the reference line can use a metric or a formula, such as the overall average for the period (average('perc-total')). The chart then shows who is above or below the overall average. See Calculations and formulas.


Filter for this chart only​

For a chart that should consider only part of the collections (for example, only rejected audits), use the search bar and filters of the editor itself, at the top of the chart area. The filter is saved with the chart and adds to the dashboard filters.

Example: a card with the number of rejections uses Count of records and, in the editor's search bar, approval : "Rejected".

Filter on a metric​

To filter only one of the chart's metrics, open the metric and, under Advanced, use Filter by. Example: a chart with two metrics side by side, "Total collections" (no filter) and "Rejected" (Filter by status : "Rejected").


Compare with the previous period​

The Time shift option, under a metric's Advanced settings, calculates the same metric shifted in time. Examples:

  • A "Previous month" series with a Time shift of 1 month ago, next to the current month series.
  • A card with the current result and, as the secondary metric, the same result with a Time shift of 1 year ago.

The shift can also be used in formulas to calculate the variation. See Variation from the previous period.


Change the chart type​

The chart type selector, at the top of the chart area, changes the type while keeping the fields already chosen. You can try the same indicator as bars, lines or a table before deciding. The suggestions, below the chart, show these alternatives ready to use.


Save the chart​

  • Save and return — saves the chart inside the dashboard you came from.
  • Save — asks for a title and, optionally, a description. With Add to library, the chart goes to the Visualize Library and can be used in several dashboards. A library chart that is changed changes in every dashboard that uses it.
  • Save as new — creates a copy, keeping the original.
Title with the unit of measure

Include the unit in the title or metric name: "Average result (%)", "Response time (days)", "Nonconformities (occurrences)". Readers shouldn't have to guess what the number means.