Start with the question you need to answer. Task counts, recorded hours and piece counts, Spot measurement data, inventory data and contract figures are based on different datasets. Similar-looking charts may therefore answer different questions.
Find and add the right report
In the browser, open Dashboard → Report pages. Select a page from the page selector at the top of the view. Adding a report and saving its settings permanently requires administrator permissions. The report figures are limited to the data the viewer has permission to access.
Select Add new report from the page toolbar. Use the Search for a report or browse reports by item field in the report catalog to search by report name or words in its description. You can also browse the sections for different datasets. Read the description and drag the appropriate report from the catalog onto the page. If a report is missing from the catalog, check your search text and the Show only reports that are not on the page option.
The new report appears on the page as a draft. You can add multiple versions of the same report to one page only if the reporting tool's additional features are enabled for your customer account. See also adding and arranging reports.
Choose the data source to suit your question
- Number of Tasks answers the question of how many tasks are included in the selection. Tasks by status breaks tasks down by their current status. The status distribution is not a historical snapshot of the tasks' statuses at the end of the period.
- Completed vs. other Tasks compares the number of completed tasks with tasks in other statuses. Completed tasks are assigned to their completion date and other tasks to their due date. The same difference in date basis also applies to the count and status reports mentioned above. Tasks on hold are excluded from these reports. Do not interpret all the figures as a set of tasks due within a single period, even if the report catalog description refers generally to the due date.
- On-time completed tasks shows what proportion of the included completed tasks were completed by their due date. It does not measure how late open tasks are.
- Hours allocated to tasks is based on the duration of task resourcing periods and the portion of those periods that falls within the reporting period. It shows allocated working time, rather than actual time calculated from employees' worktime entries.
- Recorded hours and piece counts is based on worktime entries. Choose this report when you want to break down recorded time and quantities recorded as pieces by, for example, user, task or log type.
When you need Spot measurement data, inventory data or contract values, for example, look for a report based on that dataset. Always check whether a figure represents a count, hours, a monetary amount, a measurement or a calculated proportion. You can also view a report's description using the help icon next to the title of a report added to the page.
How is the proportion completed on time calculated?
On-time completed tasks includes only tasks with the Completed status that have a completion time and a due date within the selected period. The completion does not need to fall within the same reporting period as the due date. A task completed on its due date counts as completed on time; the comparison uses the completion date, rather than the exact time of day. The date comparison uses the user's time zone, with Helsinki as the default.
The percentage completed on time is the number completed on time divided by the total number of included completed tasks, multiplied by 100. The proportion completed late is calculated in the same way. For example, if three of the four included completed tasks were completed on time, the proportions are 75% on time and 25% late.
Without grouping, the percentages are calculated for the entire selection in each time period. If you group by responsibility or priority, each group's percentage is calculated from its own set of tasks. The group percentages are not added together to produce an overall percentage. The proportions are rounded to two decimal places. For an empty dataset, both proportions are zero; zero does not then mean that all tasks were completed late.
Choose a chart type and filter the data
Open Settings in the report's title row. Open the Report settings section in the settings panel and select Chart type.
- Bar is suitable for comparing quantities across groups or time periods.
- Line is suitable for examining changes over time.
- Bar (Horizontal) helps you compare groups, especially when their names are long.
- Stacked bar, Stacked bar (Horizontal) and Stacked area help you examine the total quantity and how its parts are distributed. The parts must share a meaningful unit: stacking hours and pieces does not produce a useful total.
- Pie chart and the ring-shaped Donut chart are suitable for showing proportions of a whole. These options are available only in reports that support them.
Changing the chart type does not turn a worktime entry into measurement data or a piece count into hours. The report's appearance settings are also separate from the source data's unit or the meter's settings.
In the settings panel's Time filters section, Tme period for the data determines the period from which data is retrieved. Time grouping for data determines how it is divided in the chart, for example into days or months. Check the report's preset time selections before interpreting the figures. The dates of a relative period change as time passes; a fixed date range is suitable for examining the same historical period.
Filter the data to be examined in the All filters section and choose a breakdown in the Group by section. The available options depend on the report. More detailed time and data filters are described in report time periods and filters.
Recorded hours and piece counts
Recorded hours and piece counts shows time in hours and recorded quantities in pieces. In the Bar chart type, hours and pieces appear as separate bars. The piece count is the sum of the recorded quantity values, rather than the number of entries.
The report can include general worktime entries, entries for tasks and service requests, and lunch, vacation and sick leave entries. If you want to examine only specific work, filter the log types accordingly. Entries made on Android or iOS are included in the same dataset once they have been saved to the service, provided they fall within the viewer's permissions and the report's filters.
Filters and units
The report's All filters section contains Users, Log types, Unit types, Approved, Status and Only show entries with type. The filters work together: an entry must meet all active conditions.
Log Type identifies the kind of entry, such as Task, Service Request or Worktime entry. Type is a separate classification selected for the entry, with time or pieces as its unit. These are different grouping criteria.
Select Time (hours) or Pieces in the Unit types filter if you want to examine only one unit. Without a unit filter, both may be included. Entries without a type belong to the time unit. The Only show entries with type option excludes entries without a type; it is disabled by default.
Without a status or approval filter, the report does not represent only completed or approved entries: entries that are in progress or processed may also be included. An entry's status and approval are separate matters. Filtering for entries that are not approved also includes entries with no approval information.
How are time and pieces assigned to a period?
The calculation uses the customer account's time zone, with Helsinki as the default. This determines when the day changes and how entries are assigned to time periods.
- If a time entry ended on the same local day it started, the report uses its saved number of minutes and assigns it to the start date. The saved number of minutes is what matters here, even if it differs from the interval between the start and end times.
- For an entry that spans midnight, the duration falling within each time period is calculated. Any portion outside the report's overall period is excluded. For example, work from 23:00 to 01:00 is split into approximately one hour on each day when grouped by day.
- For a time entry that is in progress, the time falling within the selected period is calculated up to the present moment.
- The entire piece count is assigned to the start date. It is not split across days based on duration.
Minutes are converted to hours by dividing by 60. Hours and pieces are summed separately, and the totals are rounded to two decimal places in each time period and group. The total across several time periods may therefore differ slightly from a total rounded only once at the end for the entire dataset.
Hours from worktime entries are not a Spot's physical operating hours. The Machine Hours report uses the operating hours meter's history and shows the latest recorded reading for the period; it does not calculate the sum of employees' worktime entries.
Break down entries using grouping
In the Time grouping for data field, select day, week, month or year. You can also open the grouping selector in the Group by section and select up to three different levels from User, Task, Service Request, Log Type and Type.
Add a level using the Add grouping selector. Change the order using the up and down arrows next to a level, or remove a level using the trash icon. Confirm your selection with the Save button in the grouping window. This applies the grouping for viewing; saving the report permanently is a separate action.
For example, User → Log Type → Type breaks down each user's entries by log type and type. Without grouping levels, you see the total hours and pieces for each time period. Missing task, service request or type information is shown in its own group for missing information.
Check the result and save the settings
Compare the report with known source data using the same time period, unit and filters. An entry that ended on the same day it started, with 90 saved minutes, produces 1.50 hours. A piece entry with a quantity of 4 produces four pieces, rather than four hours or four entries. If the result differs from what you expected, check the date basis, time zone, status, approval and access permissions.
Name the report so that another user can understand its dataset and filters. You can change the name using Edit report information in the three-dot menu in the report's title row. A chart's color or shape alone does not tell you what a figure means.
Save a new draft using the Save the page button in the page toolbar. Saving preserves the page's reports, their order and settings, and removes the draft indicator. You can save changes to an existing report using Save Settings in its title row, which appears for administrators when the settings are open.
Saving report settings does not change the source tasks, entries or meter readings, or freeze the report figures as a historical snapshot. Reopen the page and verify that the report, chart type, time selections, filters and grouping were retained. Relative time and entries in progress can still change the result. If the report remains empty or does not load, see troubleshooting an empty report.