Analytics Charts

On this page

An analytics chart is a saved list view with a visualization added: it reads the records of one object class the way a list does, and the grouping, aggregation and percentages are worked out in the browser. A chart's definition and data are held in the browser for 60 seconds before a new fetch is considered, so two technicians looking at the same chart can see different figures for up to a minute.

Analytics charts in the Web App

What you can see and change

Three permissions decide which charts you can create, edit and share (see Permissions Reference):

Permission What it allows
Manage Personal Dashboards and Charts Create or edit a private chart.
Share Dashboards and Charts Create a shared chart, and edit a shared chart you own.
Manage Shared Dashboards and Charts Create a shared chart, and edit any shared chart that is visible to you.

The New Chart, Add to category and Delete buttons of the Analytics list, and the commands of its categories panel, are available only when you may manage personal charts or may administer shared charts. If you hold only Share Dashboards and Charts, these buttons are disabled.

Changing the bypass setting described in Bypass role-based access control needs a separate security-management permission, not one of these three.

The Analytics list

The Analytics list shows the charts that are visible to you, in the columns Name, Type and Class, sorted by name. As in other lists, you can sort by clicking a column header, filter a column from its header, group by a column, and narrow the list with the Filter items (/) box. A counter is listed like any other chart, with Counter in its Type column.

Each row links to its chart. The list's copy-link command gives an absolute link to a chart that you can paste, for example into a ticket. Whoever opens the link sees the chart only if the chart is visible to them.

Create a chart

  1. In the Analytics list, click New Chart. A full-screen dialog opens with a searchable list of object classes. Activity, All Tickets and All CIs are pinned in a highlighted block above the rest; both blocks are sorted alphabetically.
  2. Click a class. The chart is created at once, without a confirmation step, and opens in the chart editor.
  3. Set up the chart as described in Edit a chart, then click Save.

A new chart starts as a vertical bar chart that counts records, with no grouping and the default color palette. For most classes the record's creation date (for PO Item, the PO date) becomes the chart's only data field, and the date filter above the chart is set to This year so far (This week so far for Activity). A class without such a date starts with no date filter.

The object class you pick is fixed: the chart settings offer no way to change a chart's data source later.

Until its first save, a new chart is only a draft. If you close it and answer No when asked whether to save the changes, the whole new chart is abandoned and you return to the list or the dashboard.

A chart's name must be unique among the charts visible to you, whatever their object class; letter case and leading or trailing spaces are ignored in the comparison. A save that would duplicate such a name is refused, and nothing is saved.

You can also create a chart by copying an open, saved chart with Save As.

Create a chart from a dashboard

  1. On a dashboard, click Customize Dashboard.
  2. In the drawer, open the Actions menu (the three-dot button) and select New widget > Chart, Counters or Table.
  3. In the data-source picker, click a class. Activity is included in the list. The chart is created at once, as a Counter chart for Counters and a Table chart for Table, and opens in the chart editor.
  4. Click Save. The chart is stored and the editor closes.

The new chart is not placed on the dashboard. Place it from the widget palette, which lists it under Chart, Counters or Table by its type; a chart over Activity is listed under Table. See Dashboards for placing widgets.

Edit a chart

  1. Open the chart from the Analytics list, or use View details or Edit on its dashboard widget.
  2. Adjust its settings, filters, and sharing as needed. The sections below describe the available options and permission restrictions.
  3. Click Save to update the chart, or Save As to create a copy.

Open a chart from the Analytics list. On a dashboard, the View details button (eye icon; View details to see full data when the widget's data was cut) in a placed chart's title bar, shown outside edit mode, and the widget's Edit action open the same editor over the dashboard; closing it leaves you on the dashboard, and saving there reloads the widget.

An open chart starts in Visualization mode. The header has Close at the left, the chart's name in the center, and Save at the right, together with Save As for a chart that has been saved at least once.

The Chart Settings pane on the right has these tabs:

Tab What you set there
General The Name box; the chart type (Vertical bar, Horizontal bar, Line, Area, Donut, Pie, Counter or Table), not shown for a chart over Activity; for a Table chart, the table type (Summary table or Raw data table); under "Available properties to display", the Data fields list with a More button and drag handles; and, under Display, Group By and Metric.
Filter The filter builder used by lists. This filter is saved with the chart and applies to every viewer. For a chart over Activity the tab is named Activity Filter.
Object Filter Only for a chart over Activity, which is always a Table chart. Filters by a related object, from the classes available in advanced search except General Ticket, General CI and PO Item.
Options Color palette (one of eight) and Custom colors, both not for a Table chart; display options (Show chart name, Show values except on a Counter or Table, Show as percentages only where the metric counts or sums); X-axis and Y-axis labels for bar, line and area charts; Comparison for a Counter grouped by a date; and Max tiles for a Counter with grouping.
Sharing Who can see the chart, and, if you hold the security-management permission, the bypass checkbox. See Share a chart and Bypass role-based access control.
Categories Files the chart into categories. See File a chart into a category.
Dashboards Only in the editor opened from a dashboard, and only when the chart is placed on a dashboard: a read-only list of the dashboards the chart is placed on, each opening in a new tab, with a count of the dashboards you cannot see.

On the General tab:

  • The Display headings read Group By and Metric, with "(X-axis)" and "(Y-axis)" added for Vertical bar, Line and Area charts, and the other way round for Horizontal bar.
  • Drag a field from Data fields onto Group By to group by it; a field already there is not added again. Group By uses up to two fields, and one for Pie, Donut and Counter; entries past that stay in the list dimmed and are left out of the chart. A date field arrives with the interval Monthly and can use Daily, Weekly, Monthly or Yearly. Reorder Group By entries by dragging them.
  • Metric holds one entry. A numeric field dropped on it replaces the current metric, starting as a count; other fields are ignored. A metric aggregates as Count, SUM, Average, MIN or MAX, except the built-in "Count of records" entry, which has no aggregate. Removing the metric puts "Count of records" back.
  • Removing a field from Data fields also removes it from Group By and Metric. If it was the metric's field, Metric is left empty.
  • On a Table chart set to Raw data table, Group By is locked with the text "Raw data shows individual records only. To see grouped data, switch table type to Summarized data." While a grouping is still set, a warning icon with the same text sits beside the heading.

On the Options tab:

  • Under Custom colors, click a legend value to give it a Custom label (the value then shows under its new label, with the original beneath) or its own color; the color picker's reset restores that value's default color. A dot marks a value with its own color, and Reset all, shown once any color or label is set, clears both.
  • The X-axis and Y-axis boxes show the automatic label as a placeholder.
  • Comparison offers "No comparison" or the previous period; when it is on, the checkbox "Lower value is better, higher is worse" appears.
  • The Max tiles box defaults to 12 and does not go below 1.

Each change in the settings pane is saved at once to a working copy of the chart on the server, and the figures are fetched again when the change affects them. Save writes the working copy to the stored chart. Save As opens the Save Chart As dialog with the name plus "(Copy)" filled in, and creates a second chart. Reset discards your changes and returns to the stored chart.

When you close a chart with changes you can save, you are asked "Do you want to save the changes?". Yes saves and keeps the editor open; No discards the edits and closes it. When Save is unavailable (nothing changed, you may not save this chart, or the sharing selection is not accepted), Close asks nothing.

Above the chart sit runtime filters: a date field with a relative range, and an Add filter button that adds further field filters, each with its own remove button, and Clear All once one exists. If you can save the chart, a change to these filters is a chart edit like any other: Close asks to save, and Save stores the filters in the chart every viewer opens. If you cannot save the chart, the filters still change what you see, Close asks nothing, and the stored chart keeps its own filters. Exports include the runtime filters. Add filter is disabled on a chart whose data configuration is locked (see Bypass role-based access control); the date filter is not.

Besides Visualization, an open chart offers the Summarized Data and Raw Data table modes. Their rows open in a new tab, from the link cell or by a double-click. The tables start sorted by the chart's saved sorting, otherwise by the first column (descending for a date). The Export menu beside the mode switches offers chart PDF and PNG in Visualization mode, and CSV, raw CSV and JSON in each data mode.

File a chart into a category

You can file charts from two places:

  • In the Analytics list, select one or more charts and click Add to category to file them all into one category.
  • In an open chart, on the Analytics page or in the editor opened from a dashboard, use the Categories tab to file that chart into several categories at once.

A chart must be saved before it can be filed. If you add a category from inside a chart that is unsaved or has unsaved edits, you are asked to save first, and the category picker opens only if the save succeeds. Canceling that prompt cancels the category action, not your edits.

Manage chart categories

The categories panel at the left of the Analytics list has a New menu with New Category and New Subcategory, Move up and Move down arrows, and a menu with Move to top level, Move to category, Delete and Properties. Every one of these commands is disabled unless you may manage personal charts or may administer shared charts. New Category needs only that; the other commands also need a selected category.

The tree always starts with two fixed rows, All Analytics and Uncategorized, which can never be renamed, moved or deleted, and which do not count as a selected category for these commands.

Deleting a category also deletes its subcategories.

The Move to category command cannot complete a move on the analytics tree. To place a category under another one, create it in the right place instead.

Share a chart

On the Sharing tab, choose who can see the chart: Only me, Everyone, or Specific people or groups, which accepts several people and several groups at once. Charts are shared with people and groups, not with security roles. The foot of the tab shows the chart's name, its owner (Owned by), and when and by whom it was last modified.

A chart is visible to its owner and, when it is shared, to everyone (Everyone) or to the people named and the members of the groups named (Specific people or groups). No sharing setting hides a chart from its owner, and the owner cannot be removed from the audience.

Which audiences you can choose depends on your permissions:

  • The shared audiences are available if you own the chart and hold Share Dashboards and Charts, or if you hold Manage Shared Dashboards and Charts.
  • Only me is available if you hold Manage Personal Dashboards and Charts and either own the chart or hold Manage Shared Dashboards and Charts.

So with Manage Shared Dashboards and Charts you can re-share, or together with Manage Personal Dashboards and Charts make private, a chart someone else owns, as long as that chart is visible to you.

If you may not keep a chart private (you lack Manage Personal Dashboards and Charts, or you hold it but neither own the chart nor hold Manage Shared Dashboards and Charts), a new chart opens with a shared audience selected instead of Only me. A saved chart opens with its stored sharing.

If the sharing you are about to save would leave you outside the chart's audience, you are asked to confirm. Confirming saves the change, closes the editor and refreshes the list, because you can no longer see the chart.

Saving can change a chart's owner. If you save a chart someone else owns as Only me, or save changes to the chart itself rather than only to its sharing, you become its owner. Save As always makes you the owner of the copy.

If the owner's person record is deleted, the owner's private charts are deleted with it. The owner's shared charts remain, without an owner; from then on, only holders of Manage Shared Dashboards and Charts who can see such a chart can edit it.

A chart placed on a dashboard reaches a viewer only when both the chart and the dashboard are shared with them; the dashboard's audience is set separately, on the dashboard. A viewer who can open the dashboard but not the chart sees "You don't have permission to view this widget." in its place, and the widget palette does not offer them the chart. See Dashboards.

Bypass role-based access control

Under the audiences, the Sharing tab has a Security section with the checkbox Bypass role-based access control and the line "Disables role-based access control. All users will see the entire dataset, regardless of their permissions." The section appears only if you hold the security-management permission. When a chart already bypasses role-based access control, a warning beneath the section is shown to anyone who can open the tab, whether or not they can change the setting.

On a dashboard, clicking an element of a bypassing chart lists the records the chart was drawn from, including records you could not otherwise open.

A bypassing chart is marked with an icon:

  • In the Analytics list, beside the chart's name, with the tooltip "Role-based access control is bypassed. The entire dataset will be visible to all users. Be aware of the risk of exposing sensitive information."
  • On a dashboard, in the title bar of the placed chart widget, with a tooltip.
  • In the Counter Group editor, beside each bypassing counter, with a tooltip worded differently from the Analytics list's. After another technician turns the bypass on, the icon can take up to an hour to appear there.
  • In the chart editor's header, beside the chart's name, when the chart's data configuration is locked for you.

If a chart already bypasses role-based access control and you do not hold the security-management permission, its data configuration opens locked, under the text "Administrative access is required because this chart bypasses role-based access control." Locked are the Data fields list and its add button, Group By and Metric, the table type of a Table chart, the whole Filter tab, the Add filter button of the runtime filters, the Object Filter tab of an Activity chart, and the Raw Data mode. The chart type, the date runtime filter, the Options tab, the sharing audiences, and Summarized Data stay available to you.

Work with counters

A counter is a chart of type Counter, created and edited in the same chart editor as any other chart.

The Counter Group widget on a dashboard shows several counters together. In the widget's editor, the Counters section works as follows:

  • Adding an item opens a picker that lists only the Counter charts visible to you. A counter already in the list is not added again. If you close the picker without choosing a counter and without entering anything, the item dialog closes too; the dialog's Cancel button always closes it.
  • Each item has its own caption. The caption starts as the counter's name; once you edit it by hand, it no longer follows the counter's name.
  • Reorder the items by dragging them.
  • Above the list are a comparison toggle and, when comparison is on, a toggle that inverts the color logic.

An item's Edit action opens the full chart editor, with the chart type hidden and fixed to Counter. Saving there refreshes that counter's name and figures on the dashboard you are editing. See Dashboards for placing a Counter Group widget on a dashboard.

  • Dashboards - place chart, counter, and Counter Group widgets on a dashboard.