This content has been marked as final. Show 2 replies
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.