8 Replies Latest reply on May 24, 2013 6:00 AM by leo.galvan

    How do I automatically add a reference line for a value based on date?

    leo.galvan

      Hello, my data is set up in the following manner:

       

      Metric Name   |   Month/Year   |   Actual   |   Target

       

       

      I am trying to create a bullet chart view that has Sum of Sales with a Monthly Target Reference Line. This works perfectly.

       

      The problem I'm having is that I want to create a second reference line that shows [Actual] for [Month/Year] of the previous year.

       

      To Recap:

       

      I want to create a bullet chart with [Actual], use [Target] for the first reference line, then show [Actual] for [Month/Year] of the previous year.

       

      Any ideas on what I can do? I've tried using a combination of calculated fields and parameters but just can't seem to get it to happen for me. Thanks!