Work Requests

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.