2 Replies Latest reply on Aug 17, 2018 11:47 AM by Michael Murphy

    Reference Line Average for a Continuous Date with No Data within a Certain Month

    Michael Murphy



      See workbook attached.


      I am trying to determine the best way to show a true average for continuous items over time when there are no values for a particular date level (for example month).


      Within the workbook attached, you can see that the average is not correct from a business perspective. The three months missing are not accounted for during the standard average reference line.


      Appreciate all the help.