Finding an average weekly count by year

Follow

Mario Valdes II

• May 10, 2023 21:28

Hello, everyone,

I've got a workbook which contains the following data points:

• A list of roughly 8 shippers
• A list of roughly 800 destinations facilities
• A count of distinct pallet IDs shipped from each shipper to each destination by fiscal week

All I'm trying to do is find the average weekly pallet count by year and destination facility which, in my head, should be a single number per fiscal year, but I'm getting the weird break out as seen below. Am I using AVERAGE() incorrectly?

 

0

• 

  Alan Mark

  • May 10, 2023 22:30

  Hi Mario,

  Our AVERAGE function provides the average of each row for the columns specified as arguments.

  For example, if you have three columns and AVERAGE them as follows:

  AVERAGE(Column1;Column2;Column3)

  Column1	Column2	Column3	AVERAGE returns
  1	9	10	6.6666

  Here is our documentation for AVERAGE

  However, I believe you may be looking for our GROUPAVERAGE function instead.  This function returns the average value of a group by creating a sum for all values in the group and then dividing by the number of values.
  
  Hope this helps!

  Alan

  1

  Comment actions Permalink
• 

  Mario Valdes II

  • May 11, 2023 05:00

  Thank you, Alan. It appears you are correct; I didn't know GROUPAVERAGE() was a thing as I mostly relied on getting my data into Excel for the more nuanced heavy-lifting, but it appears to work as intended. Again, thank you tremendously! You've saved me a massive amount of manual work I was anticipating!

  Mario

  0

  Comment actions Permalink

Please sign in to leave a comment.