Submittals Overview Dashboard
Number of Canvases: 1
Default Canvas: Submittals Overview
Canvas/Dashboard Name: Submittals Overview
Data Source(s): Unifier
Subject Area: Unifier – Cash Flow
Datasets: Not Applicable
Dashboard
Figure 5-4 Submittals Overview
Table 51: Submittals Overview – Dimensions
| Canvas | Dimension Name | Dimension / Attribute | Subject Area / Dataset |
|---|---|---|---|
| Submittals Overview | Calendar | Project id | Unifier – Business Process History |
| Submittals Overview | Project | Project Name | Unifier – Business Process History |
| Submittals Overview | Business Process – General (BP) | Record Number | Unifier – Business Process History |
| Submittals Overview | Business Process – General (BP) | Status | Unifier – Business Process History |
| Submittals Overview | Business Process – General (BP) | Creation Date | Unifier – Business Process History |
| Submittals Overview | Business Process – General (BP) | Completion Date | Unifier – Business Process History |
| Submittals Overview | Business Process – General (BP) | Due Date | Unifier – Business Process History |
Table 52: Submittals Overview – Measures
| Canvas | Fact / Measure | Measure Type | Subject Area / Dataset |
|---|---|---|---|
| Submittals Overview | # of BP Records | Fact | Unifier – Business Process History |
| Submittals Overview | # of Open | Calculated from Fact | Unifier – Business Process History |
| Submittals Overview | # of Completed | Calculated from Fact | Unifier – Business Process History |
| Submittals Overview | # of Cancelled | Calculated from Fact | Unifier – Business Process History |
| Submittals Overview | # of Rejected | Calculated from Fact | Unifier – Business Process History |
| Submittals Overview | # of Approved | Calculated from Fact | Unifier – Business Process History |
| Submittals Overview | with Completion Date | Calculated from Fact | Unifier – Business Process History |
| Submittals Overview | Average Time (in Days) taken for Submittals Closure | Calculated from Fact | Unifier – Business Process History |
| Submittals Overview | Average Time (in Days) to Reject | Calculated from Fact | Unifier – Business Process History |
Table 53: Submittals Overview – Filters
| Canvas | Filter Type | Is Expression Filter | Dimension / Attribute / Measure | Subject Area / Dataset |
|---|---|---|---|---|
| Submittals Overview | Dashboard | No | Project Name | Unifier – Business Process History |
| Submittals Overview | Dashboard | No | Business Process Name | Unifier – Business Process History |
| Submittals Overview | Dashboard & Visualization | No | Status | Unifier – Business Process History |
| Submittals Overview | Visualization | Yes | Creation Date | Unifier – Business Process History |
| Submittals Overview | Visualization | Yes | Completion Date | Unifier – Business Process History |
Table 54: Submittals Overview – Calculated Members
| Calculated Member | Expression | Source | Subject Area / Dataset (s) |
|---|---|---|---|
| # of Open |
FILTER("Primavera - Business Process History"."Metrics"."# of BP Records" Using "Primavera - Business Process History"."General - (BP)"."Status" IN ('Approved','Pending') AND "Primavera - Business Process History"."Dates - (BP)"."Completion Date" IS NULL)
|
Derived From Fact | Unifier – Business Process History |
| # of Completed |
FILTER("Primavera - Business Process History"."Metrics"."# of BP Records" USING NOT("Primavera - Business Process History"."Dates - (BP)"."Completion Date" IS NULL) AND "Primavera - Business Process History"."General - (BP)"."Status" = 'Approved')
|
Derived From Fact | Unifier – Business Process History |
| # of Cancelled |
FILTER("Primavera - Business Process History"."Metrics"."# of BP Records" Using "Primavera - Business Process History"."General - (BP)"."Status" IN ('Cancelled','Canceled'))
|
Derived From Fact | Unifier – Business Process History |
| # of Rejected |
FILTER("Primavera - Business Process History"."Metrics"."# of BP Records" Using "Primavera - Business Process History"."General - (BP)"."Status" = 'Rejected')
|
Derived From Fact | Unifier – Business Process History |
| # of Approved |
FILTER("Primavera - Business Process History"."Metrics"."# of BP Records" USING "Primavera - Business Process History"."General - (BP)"."Status" = 'Approved')
|
Derived From Fact | Unifier – Business Process History |
| with Completion Date |
FILTER("Primavera - Business Process History"."Metrics"."# of BP Records" USING NOT("Primavera - Business Process History"."Dates - (BP)"."Completion Date" IS NULL))
|
Derived From Fact | Unifier – Business Process History |
| Average Time (in Days) taken for Submittals Closure |
SUM(CASE WHEN "Primavera - Business Process History"."General - (BP)"."Status" = 'Approved' THEN TIMESTAMPDIFF(SQL_TSI_DAY, "Primavera - Business Process History"."Dates - (BP)"."Creation Date", "Primavera - Business Process History"."Dates - (BP)"."Completion Date") ELSE 0 END) / (FILTER("Primavera - Business Process History"."Metrics"."# of BP Records" USING NOT("Primavera - Business Process History"."Dates - (BP)"."Completion Date" IS NULL) AND "Primavera - Business Process History"."General - (BP)"."Status" = 'Approved'))
|
Derived From Fact | Unifier – Business Process History |
| Average Time (in Days) to Reject |
SUM(CASE WHEN "Primavera - Business Process History"."General - (BP)"."Status" = 'Rejected' THEN TIMESTAMPDIFF(SQL_TSI_DAY, "Primavera - Business Process History"."Dates - (BP)"."Creation Date", "Primavera - Business Process History"."Dates - (BP)"."Completion Date") ELSE 0 END) / (FILTER("Primavera - Business Process History"."Metrics"."# of BP Records" Using "Primavera - Business Process History"."General - (BP)"."Status" = 'Rejected'))
|
Derived From Fact | Unifier – Business Process History |