6 Replies Latest reply on Mar 30, 2018 11:08 AM by Lauren Lisowe

    Issue with Reference Line and averages

    Lauren Lisowe

      I have a set of data that considers a cost per hour over a baseline period (year = 2017) and then a current R12 lookback period. I want to be able to show the average of each of these numbers in a BAN. that works and gives me expected data.

       

      I then am showing the R12 cost  broken down over period (discrete dates) (also works as expected). I've added a reference line to look at the baseline cost per hour. Here is where I run into a problem. It is set to be the total of the "Baseline Cost per Billable Hour" in the reference line. I've also tried with average to no avail. When I filter by only 1 city at a time the averages are spot on. When I include all stores the cost per hour in my BAN (expected result) and the reference line don't match. I believe this is due to the way the data is stretching past the original baseline dates, I just don't know how to fix it.

       

      I've attached a sample workbook.