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

      All,

       

      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.