Understanding the Percent Change
In Scorecard, the Percent Change column on the metrics table shows the change in trend during the filtered date range for the selected equipment. This value is represented by a numerical value and a colored arrow. The numerical value is derived by comparing the actual values from the start date to the end date of the filtered date range. The direction of an arrow is determined by the positive or negative percent change value of a metric. A downward arrow represents a negative percent change value. An upward arrow represents a positive percent change. The color of the arrow is determined by the metric’s correlation (positive, negative or neutral). A green arrow represents a positive trend. A red arrow represents a negative trend. A grey arrow represents a neutral trend. The percent change is shown as a numerical value along with a colored arrow. When there is no change in percentage, no arrow is displayed in the card.
The Percent Change value is the current actual value minus the previous actual value, divided by the previous actual value, all multiplied by 100. The value is calculated as [(current actual–previous actual)/previous actual]*100.
• The current actual value is the sum or average of the actual values for the 6 days prior to the end date of the filtered date range through the end date of the filtered date range, depending on the roll-up behavior. For example, in a date range from 2022–03–07 to 2022–03–31, for a metric with the aggregate roll-up behavior, the current actual value is the sum of the actual values from 2022–03–25 to 2022–03–31 inclusive.
• The previous actual is the sum or the average of the actual values for the 6 days prior to the start date of the filtered date range through the start date of the filtered date range, depending on the roll-up behavior for the metric. For example, in a date range from 2022–03–07 to 2022–03–31, for a metric with the average roll-up behavior, the previous actual value is the average of the actual values from 2022–03–01 to 2022–03–07 inclusive.
The value for the Percent Change column is always presented as a positive number, rounded to one decimal place.
The following sections provide examples of how percent change value, including the color and direction of the arrow, is calculated in different scenarios. The metric values in these examples are for the date range from 2022–03–07 to 2022–03–31. The information used in these examples is shown in the following table:
|
Metric
|
Correlation
|
Current Actual Value (2022–03–25 to 2022–03–31)
|
Previous Actual Value (2022–03–01 to 2022–03–07)
|
Difference
|
Percent Change
|
|---|---|---|---|---|---|
|
Jobs Completed
|
Positive
|
50
|
30
|
20
|
 66.6% |
|
Scrap Rate
|
Negative
|
90
|
70
|
20
|
 28.6% |
|
Overtime
|
Negative
|
120
|
200
|
-80
|
 40.0% |
|
Total Effective Time
|
Positive
|
100
|
150
|
-50
|
 33.3% |
|
Planned Production Time
|
Neutral
|
100
|
70
|
30
|
 42.9% |
|
Total Production Time
|
Neutral
|
70
|
120
|
-50
|
 41.6% |
|
Jobs Scheduled
|
Positive
|
60
|
60
|
0
|
0% |
|
Total Loss Hours
|
Negative
|
40
|
40
|
0
|
0% |
Scenario 1: Percent Change Value is Positive
In this scenario:
• represents a positive trend. An increase in the percent change value represents a positive trend for a positively correlated metric. For Jobs Completed, the current actual value (50) is better than the previous actual value (30). The number of jobs completed has increased by 66.6%.
represents a positive trend. An increase in the percent change value represents a positive trend for a positively correlated metric. For Jobs Completed, the current actual value (50) is better than the previous actual value (30). The number of jobs completed has increased by 66.6%.• represents a negative trend. An increase in the percent change value represents a negative trend for a negatively correlated metric. For Scrap Rate, the current actual value (90) is greater than the previous actual value (70). The scrap rate has increased by 28.6%.
represents a negative trend. An increase in the percent change value represents a negative trend for a negatively correlated metric. For Scrap Rate, the current actual value (90) is greater than the previous actual value (70). The scrap rate has increased by 28.6%.Scenario 2: Percent Change Value is Negative
In this scenario:
• represents a positive trend. A decrease in the percent change value represents a positive trend for a negatively correlated metric. For Overtime, the current actual value (120) is less than the previous actual value (200). Overtime has decreased by 40.0%.
represents a positive trend. A decrease in the percent change value represents a positive trend for a negatively correlated metric. For Overtime, the current actual value (120) is less than the previous actual value (200). Overtime has decreased by 40.0%.• represents a negative trend. A decrease in the percent change value represents a negative trend for a positively correlated metric. For Total Effective Time, the current actual value (100) is greater than the previous actual value (150). The total effective time has decreased by 33.3%.
represents a negative trend. A decrease in the percent change value represents a negative trend for a positively correlated metric. For Total Effective Time, the current actual value (100) is greater than the previous actual value (150). The total effective time has decreased by 33.3%.Scenario 3: Percent Change for Metrics with Neutral Correlation
In this scenario:
• indicates that the value has increased or remained the same.
indicates that the value has increased or remained the same.• indicates that the value has decreased.
indicates that the value has decreased.The Planned Production Time and Total Production Time metrics have a neutral correlation, so their increase or decrease are neither positive or negative.
Scenario 4: Percent Change Value is Zero
When the current actual value is equal to the previous actual value, there is no change in the trend, which is considered to be positive.
In this scenario:
• represents a positive trend for Jobs Scheduled, which has a positive correlation.
represents a positive trend for Jobs Scheduled, which has a positive correlation.• represents a negative trend for Total Loss Hours, which has a negative correlation.
represents a negative trend for Total Loss Hours, which has a negative correlation.Scenario 5: Percent Change Value is Undefined
When the value is undefined, for example, when the previous actual value is 0, the percent change calculation for both positively and negatively correlated metrics results in infinity. This scenario can occur during the first week of running a piece of equipment. In this scenario, the Percent Change column is blank.