Resource State Time Distribution DWH#

Description#

• This report provides information about how each resource "spends" its time over a period of time

Data Source#

• DWH Database

Assumptions#

• Calendar Days must have been generated for the Calendars of the relevant Areas.

Filters#

• Facility - Multi value filter on facilities
• Area - Multi value filter on Areas (restricted by the Facility filter)
• Shift - Multi value filter on Shifts (restricted by Area)
• Resource Type - Multi value filter on Resource Types
• Model - Multi value filter on Resource Model
• Processing Type - Multi value filter on Processing Types
• Resource - Multi value filter on Resources (restricted by Facility, Area, Resource Type and Model)
• State Model - Multi value filter on State Models
• Date Start - defines the start time threshold filter for shift start date and time where resource facts occurred
• Date End - defines the end time threshold filter for shift start date and time where resource facts occurred
• Expand All Items - true or false

Fields#

• Resource Facility
• Resource Area
• Resource Name
• Time at State per State Model [State] - duration, in hours, of how long the Resource was in that state during the period.
• Time at State per State Model [State] % - percentage of time that the Resource was in that particular state during the period.

Example#