When using Targets, you may have noticed that the Target Line starts one day prior the Target Start Date.
For example, if the Target Start Date is 1 Nov, the Target Line will show 31 Oct as shown below:
This behavior is intentional and is better understood as follows:
The graph Target Line shows the Starting Value.
The Target Start Date is when you want the calculation to start (accumulation of values).
Example: Target & Graph Logic
Let’s say you have a daily graph with a target set for the month of January starting on January 1 and ending January 31.
The starting value is $0 and the end target is $31,000.
The following table provides an insight into the logic used to calculate and display Target Lines:
Date | Target Accumulation | Target Line - | Additional Information |
Dec 31 |
| $0 | The Starting Value is set and is displayed on the graph (always the day prior to the Start Date) |
Jan 1 | $1,000 | $1,000 | Day 1 is added to the Starting Value |
Jan 2 | $1,000 | $2,000 | Day 2 is added to running total |
Jan 3 | $1,000 | $3,000 | Day 3 is added to running total and so on ... |
Jan 4 | $1,000 | $4,000 |
|
Jan 5 | $1,000 | $5,000 |
|
Jan 6 | $1,000 | $6,000 |
|
Jan 7 | $1,000 | $7,000 |
|
Jan 8 | $1,000 | $8,000 |
|
Jan 9 | $1,000 | $9,000 |
|
Jan 10 | $1,000 | $10,000 |
|
Jan 11 | $1,000 | $11,000 |
|
Jan 12 | $1,000 | $12,000 |
|
Jan 13 | $1,000 | $13,000 |
|
Jan 14 | $1,000 | $14,000 |
|
Jan 15 | $1,000 | $15,000 |
|
Jan 16 | $1,000 | $16,000 |
|
Jan 17 | $1,000 | $17,000 |
|
Jan 18 | $1,000 | $18,000 |
|
Jan 19 | $1,000 | $19,000 |
|
Jan 20 | $1,000 | $20,000 |
|
Jan 21 | $1,000 | $21,000 |
|
Jan 22 | $1,000 | $22,000 |
|
Jan 23 | $1,000 | $23,000 |
|
Jan 24 | $1,000 | $24,000 |
|
Jan 25 | $1,000 | $25,000 |
|
Jan 26 | $1,000 | $26,000 |
|
Jan 27 | $1,000 | $27,000 |
|
Jan 28 | $1,000 | $28,000 |
|
Jan 29 | $1,000 | $29,000 |
|
Jan 30 | $1,000 | $30,000 |
|
Jan 31 | $1,000 | $31,000 |
|