Forms

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.