--- alias: user-guide-resource-state-time-distribution tags: - reports description: "This report analyzes resource time allocation across various dimensions within a database" --- # 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 ![ResourceStateTimeDistribution][ResourceStateTimeDistribution] !!! note To obtain accurate data in the **Resource State Time Distribution DWH** report, the **Date Start** and **Date End** properties have to be set with a time, which needs to be aligned with the configured shifts. [ResourceStateTimeDistribution]: ../images/ResourceStateTimeDistribution.png