Calculating monthly average of projects

We need to calculate the total average of completed projects over any given number of months—without being tied to a specific or fixed time period. For example:

  • We may want the average for January, March, and December (3 months),
  • Or December and February (2 months),
  • Or any other combination.

This must be flexible—the number of months can change at any time depending on what we need to analyze. The goal is to get the total number of completed projects divided by however many months are selected, regardless of whether they are consecutive or not. Is this something we can implement?

8 replies