...
The ‘Use Target Values on Label’ tick box can be used to also add the values that have been specified in the Target area From and To fields to the target line. This option is useful when you have used a Max or Min value for example.
Example
This example shows that a target line has been added to the chart that represents the average number of employees. The colour of the target line has been changed and a label has been added to provide clarity.
...
| Info |
|---|
If a label in not added, you can still see target information by hovering anywhere over the target line. |
...
It is also possible to use a pre-existing numeric measure in the Target area, which will indicate a different target value for each bar in your chart. The measure must already exist in the database and must be entered in the following way on the Target screen - #~Measure Name~#.
Example
The following example shows that a pre-existing measure (Attrition %) has been used in the Value From field only.
...
This will plot a variable Area Type chart behind your current data.
...
Example
The following example shows that a pre-existing measure (Attrition %) has been used in BOTH the Value From and To fields.
...
This will plot a variable Line Type chart in front of your current data.
...