Adding a Target line that is horizontal in a Line graph is very easy

1. Add a new value

2. Click the Fx button (function button)

3. Open

   

4. Enter “the number” in this case 0.5

5. Open

   

    

6.  

Variable Target Lines :

“I have a set target, how do I create a moving target?”

This recalls High School math :

Y = Mx+B

if you want to create a Ramp Equation you will need the following information to provide the 'x' term in that equation :

• Rsum(Count(([Days in Calendar DateTime])))

This means “Rolling SUM of Count of Days which will equal 1 per time element.

This allows you to create a Ramp Equation.

In my example I am comparing to a fraction, so I need to multiply by a 0.01 scaling factor to even appear on the graph. You will need to adjust your equation to match your requirements.