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
| Area | Where it is | What it does |
|---|---|---|
| Field list | Left column | Data source selector, field search and all available fields, grouped by type. Fields can be dragged onto the chart. |
| Chart area | Center | Shows 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 toolbar | Above the chart | Appearance, labels, legend and axis buttons. The buttons change according to the chart type. See Formatting and style. |
| Suggestions | Below the chart | Ready-made variations of the current chart (other types, other combinations). Click a suggestion to apply it. |
| Configuration panel | Right column | The 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:
- Open the editor and check, in the top left corner, that the data source is correct.
- In the chart type selector, choose Bar.
- 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. - In Vertical axis, choose the result field (for example,
perc-total). Change the function to Average. - In Name, type "Average result". In Value format, choose Number, with 1 decimal and the
%suffix. - In the editor's time range, choose the desired range, for example Last 1 year.
- Click Save and return (if you came from a dashboard) or Save, and give the chart a title.
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:
| Dimension | On screen | What it receives | Example |
|---|---|---|---|
| Horizontal axis | Horizontal axis | A grouping: dates, categories or ranges | Months, sites, shifts |
| Vertical axis | Vertical axis | One or more metrics (calculations) | Average result, number of collections |
| Breakdown | Breakdown | A grouping that splits each bar or line | Status, 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:
| Grouping | On screen | Groups by | Example |
|---|---|---|---|
| By date | Date histogram | Hour, day, week, month or year | Month-by-month closing |
| Top values | Top values | The values of a text field | Site ranking |
| Number ranges | Intervals | Ranges of a numeric field | Temperature or age bands |
| Filters | Filters | One search bar expression per group | Split forms, build a funnel |
Date histogram
| Option | What it does |
|---|---|
| Minimum interval | The size of each group: Auto, hour, day, week, month, year. With Auto, the size changes with the selected time range. |
| Customize time interval | Allows intervals such as 2 weeks or 3 months. |
| Include empty rows | Shows intervals without collections (with zero or empty value), so the timeline doesn't skip months. |
| Drop partial intervals | Hides the first and last intervals when they are incomplete (for example, the current half-finished month). |
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
| Option | What it does |
|---|---|
| Number of values | How many values to show (for example, 10 sites). The default is usually 3 or 5: increase it when the list is longer. |
| Rank by | The sort criterion: one of the chart metrics, the number of collections or alphabetical order. |
| Rank direction | Descending (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 field | Shows a group for collections where the field is empty. |
| Include values / Exclude values | Shows only some values or hides specific values (for example, a test site). |
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:
| From | To | Label |
|---|---|---|
| 60 | Below 60 | |
| 60 | 70 | 60 to 70 |
| 70 | 85 | 70 to 85 |
| 85 | 85 or more |
The "From" value is included in the range and the "To" value belongs to the next one.
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.
| Use | Expression | Label |
|---|---|---|
| Split forms | _index : *site-a* | Site A |
| Funnel stages | tested : "Yes" | Tested |
| Funnel stages | result : "Positive" | Positive |
| Funnel stages | referred : "Yes" | Referred |
| Groups of several categories | shift : (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.
- In Breakdown, choose the field (for example,
status). The Top values function is selected automatically. - Adjust Number of values to show every category.
- 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:
| Mode | On screen | Shows |
|---|---|---|
| Stacked | Stacked | The total of each group and the share of each category. |
| Side by side | Unstacked | Each category in its own bar, to compare values. |
| Percentage | Percentage | The share of each category, with every bar adding up to 100%. |
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.
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.
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 type | On screen | Use |
|---|---|---|
| Chart | Visualization | Another series, with another type or data source (for example, bars with total collections and a line with the average). |
| Reference line | Reference lines | Targets, limits and tolerances. |
| Annotation | Annotations | Mark 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
- In the editor, click Add layer → Reference lines.
- In Reference line value, choose Static value and type the target (for example,
70). - 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.
- For more than one reference (for example, minimum and maximum temperature limits), click Add or drag-and-drop a field in the same layer.
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.
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.