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)
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 |