3 Replies Latest reply on Oct 16, 2017 3:47 AM by Brent Mathison

    Average line of weekly data ignores weeks with no data

    Camille Stephan

      Hi

      I am using the SUM(Number of Records) as a counter with a weekly Date field.

      When inserting the Average Line (per pane), the line ignores weeks with no data and only averages weeks with data.

      I would like average to be calculated using all weeks displayed.

      Look at picture, average of 25 and 1 is 13, but it should be much less if considering weeks with 0's.

      I appreciate any help you can provide.

      Thanks

       

      WeeklyAverage.JPG