Important general rules discussed in this document that everyone should be aware of when creating dashboards:
...
| 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
...
Production Combined Dashboard
| Tip |
|---|
Fixed incorrect Expected Runspeed |
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]
...
| Tip |
|---|
Fixed incorrect Actual Runspeed |
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]
...