The Work Requests dataset lists requests for work, for tracking what was raised, approved or rejected and where it came from.
At a glance
| Item |
Value |
| Picker heading |
Data Tables |
| One row is |
One Work Request |
| Presentations |
Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area |
| Default presentation |
Table |
| Default period |
None. Use the Within filters instead. |
| Date basis |
None |
| Default filter |
Created Within set to Last 30 Days |
| Default columns |
Notification #, Title, Status, Priority, Team, Department, Asset Number, Area, Location, Work Order, Created At, Asset Description, Task Code, Modifier Code |
| Group Modes |
Detail tables. Charts are Consolidated. |
| Drill-through |
Column Chart only |
Measures
| Measure |
Unit |
Aggregation |
Definition |
| Work request count |
Work Requests |
Count |
Number of Work Requests. |
Columns
| Column |
Type |
Description |
| ID, Notification # |
Mixed |
The Work Request's internal ID and number. |
| Title |
Text |
The Work Request's title. |
| Status, Priority |
Text |
The Work Request's status and priority. |
| Team |
Text |
The assigned team. |
| Department |
Text |
The Work Request's own department. |
| Area, Location |
Text |
Where the work is needed. |
| Source |
Text |
Where the defect was identified. |
| Task Code, Modifier Code |
Text |
The codes on the Work Request. |
| Part |
Text |
The linked part. |
| Work Order |
Text |
The linked Work Order. |
| Requester, Requester Email |
Text |
Who raised it. |
| Created At, Updated At |
Date |
When it was created and last updated. |
| Asset Number, Asset Description |
Text |
The Work Request's Asset. |
| Asset Department |
Text |
The Asset's department. |
| Class, Group, Asset Type, Manufacturer |
Text |
The Asset's classification. |
| Asset Status, Criticality, Planning Type, Hire Status |
Text |
The Asset's details. |
| Project, Customer |
Text |
The Asset's Project and Customer. |
Filters
| Filter |
Choice |
Behaviour |
| Created Within |
One choice |
Created in the last 24 Hours to 180 Days, or a Custom Date Range. |
| Approved Within |
One choice |
Approved in the last 24 Hours to 180 Days, or a Custom Date Range. |
| Rejected Within |
One choice |
Rejected in the last 24 Hours to 180 Days, or a Custom Date Range. |
| Created At |
One choice |
Age filter: created at least 7, 30, 60 or a custom number of days ago. |
| Status, Priority, Source |
Multiple |
The Work Request's values. |
| Team |
Multiple |
The assigned team. |
| Department |
Multiple |
The Asset's department, or else the Area's, or else the Work Request's own. |
| Area, Location |
Multiple |
Where the work is needed. |
| Task Code, Modifier Code |
Multiple |
The codes on the Work Request. |
| Work Order |
Multiple |
The linked Work Order. |
| Asset Number |
Multiple |
The Work Request's Asset. |
| Asset Department |
Multiple |
The Asset's department. |
| 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. |
| Project, Customer |
Multiple |
The Asset's Project and Customer. |
Group By
| Group By |
Groups by |
| By Status, By Priority, By Team |
The Work Request's values. |
| By Department |
The Work Request's own department. |
| By Area, By Location |
Where the work is needed. |
| By Work Order |
The linked Work Order. |
| By Asset |
The Work Request's Asset. |
| By Asset Department |
The Asset's department. |
| 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. |
| By Project, By Customer |
The Asset's Project and Customer. |
Chart notes
- Line and Area charts draw one point per group, because this dataset has no time periods.
- Series by, Compare and Compare with are not available.
Business rules
- The Within filters replace the Period. A new widget starts on requests created in the last 30 days. Clear Created Within to see all requests.
- Within filters combine. Setting Created Within and Approved Within shows only requests that match both.
- Age and Within are different. Created At finds requests older than a number of days. Created Within finds requests newer than a date.
- Notification means Work Request. Notification # is the Work Request's number.
For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.