Using Measures in Target Lines

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.