4 Replies Latest reply on Feb 2, 2019 10:39 PM by May Ali

    Calculating an average for each Weekday

    Paul Boyle

      I am trying to get a bar graph for each weekday to calculate total amount of sales.

       

      See attached data set.  The calculation I would expect to be something like this.

       

      (Sum of sales for that day) / (Number of that weekdays in the data set)

       

      Mon: (453 + 21) / 2

      Tue: 4567 + 200 / 2

      .

      .

      .

      Fri: (10 + 11 + 190 + 15) / 2

       

      See attached also the type of chart I would like.

       

      Any help appreciated as not been able to work out how to do this?

       

      Thanks

      Paul