Tracking Maintenance Status Dashboard
Description: Tracking open and closed work orders by week over time.
Number of Canvases: 4
Default Canvas: Issues
Canvas/Dashboard Name: Tracking Maintenance Status
Data Source(s): Unifier
Subject Area: N/A
Datasets: Created and Completed BP Overtime Dataset
Dashboard(s)
Figure 36: Tracking Maintenance Status Issues
Figure 37: Tracking Maintenance Status By Building
Figure 38: Tracking Maintenance Status Table
Figure 39: Tracking Maintenance Status Details
Table 55: Tracking Maintenance Status – Dimensions
Canvas | Dimension Name | Dimension / Attribute | Subject Area / Dataset |
|---|---|---|---|
Issues by Building |
| Week Name | Created and Completed BP Overtime Dataset |
All Canvases |
| Status | Created and Completed BP Overtime Dataset |
By Building Table |
| Project Name | Created and Completed BP Overtime Dataset |
Table Details |
| Project Name (Root Level) | Created and Completed BP Overtime Dataset |
Table Details |
| Project Hierarchy Name Level 1 | Created and Completed BP Overtime Dataset |
Details |
| Record Number | Created and Completed BP Overtime Dataset |
Details |
| Title | Created and Completed BP Overtime Dataset |
Table 56: Tracking Maintenance Status – Measures
Canvas | Fact / Measure | Measure Type | Subject Area / Dataset |
|---|---|---|---|
Issues By Building Table | # of BP Records | Fact | Created and Completed BP Overtime Dataset |
Issues By Building | # of Created BP Records | Calculated from Fact | Created and Completed BP Overtime Dataset |
Issues By Building | # of Completed BP Records | Calculated from Fact | Created and Completed BP Overtime Dataset |
Table 57: Tracking Maintenance Status – Filters
Canvas | Filter Type | Is Expression Filter | Dimension / Attribute / Measure | Subject Area / Dataset |
|---|---|---|---|---|
All Canvases | Dashboard | No | Project Portfolio Name | Created and Completed BP Overtime Dataset |
All Canvases | Dashboard | No | Project Name | Created and Completed BP Overtime Dataset |
All Canvases | Visualization | No | Status | Created and Completed BP Overtime Dataset |
All Canvases | Dashboard & Visualization | No | Business Process Name | Created and Completed BP Overtime Dataset |
Issues By Building | Dashboard & Visualization | No | Open Cases Tag | Created and Completed BP Overtime Dataset |
Table 58: Tracking Maintenance Status – Calculated Members
Calculated Member | Expression | Source | Subject Area / Dataset (s) |
|---|---|---|---|
# of Created BP Records | CASE WHEN XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Creation Date" >= XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Week Start Date" AND XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Creation Date" <= XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Week End Date" THEN 1 ELSE 0 END
| Derived From Fact | Created and Completed BP Overtime Dataset |
# of Completed BP Records | CASE WHEN XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Completion Date" >= XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Week Start Date" AND XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Completion Date" <= XSA('demouser'.'Created and Completed BP Over Time Dataset')."Columns"."Week End Date" THEN 1 ELSE 0 END | Derived From Fact | Created and Completed BP Overtime Dataset |
Related Topics
Last Published Friday, December 8, 2023