Important general rules discussed in this document that everyone should be aware of when creating dashboards:
[ReasonState] is the preferred metric when dealing with downtime/slow running/micro stoppage/etc. reasons. This means this is preferred over [Reason] metric, and in most cases also [State] metric (unless the goal is to focus strictly on a true Machine State).
Users should avoid adding machine “activity-level” metrics to Dashboard-level filters. These include metrics like:
ReasonState
Scrap Reason
Reason Name
ReasonState Group
etc.
These metrics should be at the Widget-level in almost all cases.
Safe/recommended metrics to add to Dashboard-level filters are anything not directly related to a machine’s “activity” (state, reason, scrap reason, etc.). Examples of safe Dashboard-level filters include:
Shift
Plant
Area
Machine Name
Job Name
Job Filter
etc.
There are 2 libraries of widgets available: our officially maintained “Widget Library”, which has all our most up-to-date widgets, and our “Legacy” widgets library, which contains some of the most commonly used tables and charts from our Flash platform. We are offering both to our customers to help this transition off our Flash platform, but we highly recommend using our officially maintained Widget Library moving forward, especially with new customers.
Table of Contents:
Continuous Improvement Dashboard
Fixed formula: Total Scheduled Downtime Hours
Widget affected:
Previous incorrect:
Updated: filtered correctly for downtime state
FORMULA:
([Total Scheduled Hours], [ReasonState Type])
THEN: click on the blue [ReasonState Type] field > Filter > by only Downtime
Fixed formula: Total Downtime Hours
Widget affected:
Previous incorrect:
Updated: filtered correctly for downtime state
FORMULA:
([Total Total Hours], [ReasonState Type])
THEN: click on the blue [ReasonState Type] field > Filter > by only Downtime
Updated metric: ReasonState Group
Widget affected:
Previous incorrect:
Updated: changed [Reason Group1] to [ReasonState Group1]
What does this mean?
Have been informed that our customers prefer the behavior of ReasonState over Reason.
Reason = show only reasons
State = show only states
ReasonState = show reasons when available. When not available (operator did not enter a reason), then show the state
Updated table: fixed columns that were not accurate
Widget affected:
Previous incorrect:
Updated:
Columns:
ReasonState
ReasonState Occurrences
Total Scheduled Hours
Total Hours
Updated Dashboard-level filters to avoid issues with data filtering
We’ve identified certain use cases where dashboard-level filters may inadvertently cause “No Results” to display in some widgets. More details below.
Widget affected: DASHBOARD-LEVEL FILTERS
Updated:
Removed anything related to either Reasons (ReasonState, Scrap Reason, Reason Group, etc.)
Rationale:
The dashboards do not appear to filter well when there are Reason or State-type filters at dashboard filter level (scrap reasons, downtime reasons, state reasons, state, reasonstate, etc.)
It is highly recommended that customers who need to filter by these should do it at widget-level
Rule of thumb for deciding when to use Dashboard vs. Widget-level filters:
Dashboard filters should stay limited to “anything not directly related to a machine’s recorded status/state/issues”
Examples of safe dashboard filters: Machine Name, Area, Plant, Shift, Calendar DateTime, Job Name, Job Filter x, etc.
Widget filters are where you can better isolate your filtered data at machine’s “activity” level
Examples of safe widget filters: ReasonState, Scrap Reason, etc. along with any other filter (Date, Shift, etc. these are always safe)
Executive Dashboard
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:
Row 1:
KPI Cards
Row 2:
“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
Row 5:
“Facility Good vs. Scrap” – bar chart comparing good vs. scrap at plant level
Row 6:
“Downtime Plant level” - bar chart comparing plant and total hours – Downtime filter missing
Updated: The following rows of widgets (left to right) now exist:
Row 1:
KPI Cards
Row 2:
“Facility OEE” - bar chart of OEE per plant
“OEE Trends” - line chart of OEE, Perf, Avail, Qual %
Row 3:
“Machine level OEE”
Row 4:
“Production by Plant” - bar chart of total production per plant → includes total, good, scrap
“Production by Machine” - bar chart of total production per machine→ includes total, good, scrap
Quality Dashboard
Removed Scrap Reason from dashboard-level filter as it was causing issues, rendering widgets with “No Results”
It is highly advised that anything related directly to a machine-level activity (e..g. ReasonState, Scrap Reason, Scrap Group, etc.) should be at widget-level filters from now on, NOT dashboard level filters.
Dashboard filters work very well with anything above the machine’s direct activity (e.g. Machine Name, Shift, Job, Job Filter, Plant, Area, Calendar DateTime, etc.)
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
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]
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]
Fixed Cycle Factor in Job Summary Table
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
Brand new dashboard with all job-related variance metrics
SLX is introducing a simplified Job Variance dashboard, which brings in the metrics customers are familiar with from the Flash report variance tables. However, it has an easy-to-understand formula structure and tool-tips for convenience, ensuring everyone understands what is going in to each calculation.
Most widgets adhere to the following structure:
Expected Job <metric>
Actual Job <metric>
Variance of <metric>
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
Legacy Widgets Library
The most common reports from Flash reporting platform re-created in our new Analytics portal
Shoplogix is offering transition widgets for existing customers who are used to the structure of their Flash reports. We’ve picked the most commonly used Flash tables and re-created them in our new Analytics portal.
These are not “migrated” from one platform to the new one, but rather re-created, which means some elements or widgets may not look exactly the same, but as close to a representation as possible without further custom dev work.
Example screenshot of Legacy widgets library:
Note on these Legacy Widgets:
DEC 14, 2020:
⚠️Shoplogix does not recommend using these for new customers from Jan 2020 onward, as we don't plan to make further updates to these legacy widgets.
Instead, we recommend using our "Out of the Box Dashboards" (Production, Continuous Improvement, Quality, Executive, and Job Variance dashboards), along with our officially maintained Widget Library (which has a similar drag-and-drop "pick-your-widget" structure as this dashboard, but with updated widgets)