1 Reply Latest reply on Feb 2, 2019 3:17 AM by Nick Parsons

    Reference Line which Changes over Time

    Emma Anderson

      Currently, I have a line graph which shows an average line for a measure (built by calculated field) over time (quarters). I would like to add a reference line (most likely median with Quartiles, although a box plot would be ideal) to the Aspiring AVG calculated field, but I need the reference line to be calculated for each quarter. Basically, the reference line should move up and down as time passes, just as the current Aspirin AVG variable does, instead of remaining constant across the entire graph.

      packaged workbook attached.

       

      Thank you!!