2 Replies Latest reply on Apr 10, 2013 11:26 AM by alan.zaccone

    Placing target line on same graph as live-updating values

    alan.zaccone

      I have a measure (tshirts) that I would like to track on a line graph against a calculated field that represents the tshirt goal for Q2 2013. I have created the calculated field using this calculation:

       

      68861 + MAX(DATEDIFF('day',#April 1, 2013#,[DateAson]))*12.51648

       

      Adding 12.51 tshirts per day (from total of 68861 on April 1) will get us to our Q2 goal of 70,000 tshirts on June 30, 2013. DateAson is the date that feeds through from the DB for every record.

       

      I would like these lines to show up on the same graph. I can't get it to work with a reference line.

       

      Any ideas?