| Info |
|---|
Important general rules discussed in this document that everyone should be aware of when creating dashboards:
These metrics should be at the Widget-level in almost all cases.
|
...
| Tip |
|---|
Fixed formula: Total Scheduled Downtime Hours |
Widget affected:
...
Previous incorrect:
...
Updated: filtered correctly for downtime state
...
| Code Block |
|---|
([Total Scheduled Hours], [ReasonState Type]) |
THEN: click on the blue [ReasonState Type] field > Filter > by only Downtime
...
| Tip |
|---|
Fixed formula: Total Downtime Hours |
Widget affected:
...
Previous incorrect:
...
Updated: filtered correctly for downtime state
...
| Code Block |
|---|
([Total Total Hours], [ReasonState Type]) |
THEN: click on the blue [ReasonState Type] field > Filter > by only Downtime
...
| Tip |
|---|
Updated metric: ReasonState Group |
Widget affected:
...
Previous incorrect:
...
Updated: changed [Reason Group1] to [ReasonState Group1]
...
| Tip |
|---|
Updated table: fixed columns that were not accurate |
Widget affected:
...
Previous incorrect:
...
Updated:
...
Columns:
ReasonState
ReasonState Occurrences
Total Scheduled Hours
Total Hours
...
Widget affected: DASHBOARD-LEVEL FILTERS
...
Updated:
Removed anything related to either Reasons (ReasonState, Scrap Reason, Reason Group, etc.)
...
| Tip |
|---|
Overhaul of dashboard – overall change to widget layout to better reflect Executive workflow, and correction of widgets, removal of duplicate metrics |
Widgets affected:
...
Previous incorrect: The following rows of widgets (left to right) existed:
...
“Machine Type Pending” text field – incorrect label, not needed
Bar chart of OEE at machine level – Machine level should not be this high up in dashboard
OEE at plant level
Row 3:
“Facilities” - a repeat of OEE at plant level
Row 4:
“Facility Production” - bar chart of total production per plant
...
“Downtime Plant level” - bar chart comparing plant and total hours – Downtime filter missing
Updated: The following rows of widgets (left to right) now exist:
...
Widget affected: dashboard filters
Previous incorrect: Scrap Reason (and in some versions, Reason Name) were present in dashboard-level filters
...
Updated: Removed all instances of “Reason”s
...
Widgets affected: Production Summary Table
...
Previous incorrect: sum([Job Expected Runspeed]) is incorrect, should be [Average Job Rate]
...
Updated: Replaced metric with [Average Job Rate]
...
Widgets affected: Production Summary Table
...
Previous incorrect: sum([Total Production])/[Total Scheduled Hours], we need field for uptime hours
...
Updated: Replaced metric with SUM([Total Production])/[Total Uptime Hours]
...
Widgets affected: Job Summary Table
Previous incorrect: Currently, SUM([Job Cycle Factor]), should be Average job cycle factor.
...
Updated: AVG([Job Cycle Factor])
...
...
Job Variance Dashboard
| Tip |
|---|
Brand new dashboard with all job-related variance metrics |
The following primary formulas are introduced in this new dashboard:
How is Job Variance being calculated?🔎
(Expected Job Runtime + Expected Job Setup) - (Total Scheduled Hours - Unscheduled hours that contain Speedloss and Uptime)
How is Job Setup Variance being calculated?🔎
(Expected Job Setup time) - (Total Scheduled Hours during Setup state)
How is Job Runtime Variance being calculated?🔎
(Expected Job Runtime) - (Total Uptime Hours and Uptime hours during Unscheduled time)
How is Job Production Variance being calculated?🔎
Total Production including Unscheduled - Expected Job Production