The Forms dataset lists Forms and their progress, for counting completed and outstanding Forms by template, type or Asset.
At a glance
| Item |
Value |
| Picker heading |
Data Tables |
| One row is |
One Form |
| Presentations |
Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area, Sparklines, Heatmap, Grouped Line |
| Default presentation |
Table |
| Default period |
Last 30 Days. Time charts start on Last Month. |
| Date basis |
Completed At, the only option |
| Default columns |
Form Name, Asset, Department, Work Order, Completed By, Completed At, Assigned To, Asset Description |
| Group Modes |
Detail tables. Charts are Consolidated. |
| Drill-through |
Column Chart only |
Measures
| Measure |
Unit |
Aggregation |
Definition |
| Form count |
Forms |
Count |
Number of Forms. |
Columns
| Column |
Type |
Description |
| Form #, Form Name |
Text |
The Form's number and name. |
| Form Type |
Text |
The Form's type. |
| Status |
Text |
Unassigned, Assigned, In Progress or Complete. |
| Work Order |
Text |
The linked Work Order. |
| Assigned To, Completed By |
Text |
Who the Form is assigned to, and who completed it. |
| Assigned At, Started At, Completed At |
Date |
The Form's key dates. |
| Department, Project, Customer |
Text |
The Form's own values. |
| Asset, Asset Description |
Text |
The Form's Asset. |
| Asset Department, Asset Project, Asset Customer |
Text |
The Asset's values, which can differ from the Form's own. |
| Class, Group, Asset Type, Manufacturer |
Text |
The Asset's classification. |
| Asset Status, Criticality, Planning Type, Hire Status |
Text |
The Asset's details. |
Filters
| Filter |
Choice |
Behaviour |
| Form Name, Form Type |
Multiple |
The Form's template and type. |
| Status |
One choice |
All, Unassigned, Assigned, In Progress or Complete. |
| Started At |
One choice |
Age filter: started at least 7, 30 or 60 days ago. |
| Assigned To, Completed By |
Multiple |
The people on the Form. |
| Department |
Multiple |
The Form's own department. |
| Asset Number |
Multiple |
The Form's Asset. |
| Asset Department, Asset Project, Asset Customer |
Multiple |
The Asset's values. |
| Class, Group, Asset Type, Manufacturer |
Multiple |
The Asset's classification. |
| Asset Status, Criticality, Planning Type |
Multiple |
The Asset's details. |
| Hire Status |
Yes, No, All |
Whether the Asset is on hire. |
Group By
| Group By |
Groups by |
| By Form Template |
The Form's template. |
| By Form Type |
The Form's type. |
| By Asset |
The Form's Asset. |
| By Asset Department, By Asset Project, By Asset Customer |
The Asset's values. |
| By Class, By Group, By Asset Type, By Manufacturer |
The Asset's classification. |
| By Planning Type, By Asset Status, By Criticality |
The Asset's details. |
| By Hire Status |
On Hire or Off Hire. |
Chart notes
- Series by, Compare and Compare with are not available.
Business rules
- Forms with no date stay in. The Period matches the date a Form was completed, read from its last update. Forms with a blank date are still included.
- Not every row is complete. To count completed Forms only, set Status to Complete.
- The Form and its Asset can differ. Department, Project and Customer are the Form's own. Use the Asset versions for the Asset's values.
For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.