...
Pre-requisites
| Table of Contents | ||
|---|---|---|
|
Establishing Trends
System→ Projection Config
...
To calculate the trend, we'll start with the most recent day in the collection. We'll iterate backwards through the days, for n number of days, where n is the number of days configured. For each of those day's we'll sum the actual and standard value. To determine the trend, we'll get the difference by subtracting the total actual from the total standard, and then calculate the percent change by dividing the difference by the actual value.
Before we determine that this is the trend, we'll compare it to the min and max settings for the configuration. If our calculated value exceeds either of these settings, it is replaced with the setting value itself.
...