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?
What you’re describing sounds like it should be possible within dashboard filters, but may require some supporting automation and a particular board layout to help you facilitate what you’re doing if you’re not already tracking project completion specifically.
Would you be open to connecting on a call and showing us your boards for discussion?
Also interested to understand how far back you would want to be able to see this for…