Widget and Chart Options

All datasets share the settings below, and each dataset entry lists only what differs. A setting appears in Configure widget only when the chosen chart type can use it.

Chart types

Presentation Use it for Key settings
Table Records, or one total row per group Columns, Sort By, Group By, Group Mode
Metric Tile One headline number Measure
Bar Chart Ranking groups, especially with long names Measure, Group By
Column Chart Comparing groups side by side Measure, Group By
Column Chart Over Time, Line Chart Over Time, Area Chart Over Time Totals per period, overall or by group Measure, Group By (optional), Time interval, Compare with
Line Chart A trend over time Measure, Time interval
Area Chart A trend with emphasis on volume Measure, Time interval
Sparklines Compact trends Measure, Time interval
Grouped Line Chart One trend line per group Measure, Group By, Maximum series
Heatmap Chart Intensity by day or period Measure, Group By (optional)
Pie Chart, Donut Chart Share of a whole Measure, Group By
Treemap Chart Share of a whole with many groups Measure, Group By
Stacked Bar Chart, Stacked Column Chart Groups split by a second field Group By, Series by, Maximum series
Double Line Chart Two related values over time Compare, Time interval
Mixed / Combo Chart Two related values across groups Compare, Group By
Gauge Chart Progress against a target Measure, Chart target

Each dataset offers a subset of these. The three Over Time charts are available on Work Orders, Events & Downtime, Asset Performance and Timesheet Details. See Presentations under At a glance on its page in the Data Dictionary.

Settings

Setting What it does
Measure The number to plot.
Compare with Adds measures to a Bar, Column, Line, Area or Over Time chart, up to four in all, or two on Timesheet Details. A second unit is drawn on a right-hand axis, except on Bar charts. On an Over Time chart, each group gets one series per measure.
Chart shows On Bar and Column charts, Group draws a bar per group and Measures draws a bar per measure. All measures must share a unit.
Period The date range. Options are listed under Periods below.
Time interval The size of each period on a time chart: Day, Week or Month. Weeks start on Monday.
Group By The field that creates the categories or table groups.
Group Mode Detail draws individual records in each group. Consolidated draws one total per group. Pie, Donut and Treemap charts are always Consolidated.
Series by The second field that splits a stacked chart.
Compare The fixed pair of values on a Double Line or Mixed / Combo chart.
Chart target The positive number a Gauge measures against.
Sort By Orders the table and View records. Once you change it from the report default, it also orders the chart.
Maximum categories / periods How many groups or periods to show.
Maximum series How many lines or stack segments to show.

Periods

Period options are No Date Range, Custom Range, Yesterday, Last 24 Hours, Last 7 Days, Last 30 Days, Last 365 Days, Last Week, Last Month, Week to Date, Month to Date and Year to Date. Time charts need a bounded period, so No Date Range is not available for them.

Periods use each viewer's timezone, so viewers in different timezones can see different boundaries.

Limits

Limit Value
Maximum categories / periods 30 by default, up to 50, or 100 on some time charts. A Heatmap or Over Time chart can show up to 366.
Maximum series 10 by default, up to 20. Administrators can change both in Application Settings.
Records behind a chart built from rows 5,000. Above this the chart asks you to narrow the filters.
Data freshness Results can be up to 5 minutes old. Use Refresh data to reload them.
Widget load time 120 seconds by default, from 1 to 120. Administrators can change this in Application Settings. A slower widget stops and shows a timeout message.

When there are more groups than the maximum, the chart keeps the largest. Pie, Donut and Treemap charts combine the rest as Other, and so do stacked charts when there are more series than the maximum.

A Column Chart Over Time with one measure stacks its groups, and groups past Maximum series combine as Other. Percentages and averages on Asset Performance are not stacked. On an Over Time chart, compared measures share Maximum series, so 10 series with two measures shows 5 groups. Other can't be drilled into.

Filters

A widget has its own filters on its Filters tab, and Dashboard filters apply on top of them. When both are set, the widget shows only records that match both. Dashboard filters cover Asset fields such as Department, Asset Number, Class, Group, Manufacturer and Criticality. Stock Items and Suppliers are not linked to Assets, so Dashboard filters do not narrow them. Choosing a Department also includes its child Departments on Work Orders, Work Order Details, Work Requests, Forms, Timesheet Details, Assets, Meter Readings and Asset Performance.

To see what each dataset offers, see the Data Dictionary.