...
Pre-requisites
Table of Contents | ||
---|---|---|
|
Establishing Trends
System→ Projection Config
...
The Projection Configuration will need to be assigned to the flock or can be set on flocks contract.
What Calculations are Trended?
...
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.
We add this difference to one, and multiply it by the standard value we are establishing the trend for. Then, we add that value along with it's original standard value to the collection, and pass the trended result back to be used in reporting.
Our trends are only as accurate as the data we enter. Daily transaction entry and standards will guarantee the most accurate trend, but not everyone reports all their transactions daily. When records are entered intermittently, for any period other than a day, the value will be evenly distributed across all prior days since the last entry. This will not happen for the first record entered- only subsequent records that are not reported daily thereafter.
...
Note that if we omit data for a day for any of the above criteria, it does not count towards the total number of days we are including to establish the trend. The calculation will work backwards until the first placement of the flock to find accurate records.