ryancaseymcshane
New Member
- Joined
- Sep 16, 2015
- Messages
- 6
I am creating a dashboard for which one of the data displays will dynamically read the maximum and average values for projects that overlapped. To achieve this value, I have a separate tab that contains respective jobs' start and end dates.
How would I determine the maximum overlap of projects, as well as the average value?
Scenario
Let's say April was the busiest time of the year for projects, and at some point during that month I had 25 jobs active at the same time. What formula can I use to achieve that 25 value.
Also, what formula can I use to determine "on any given day in the year," there is an average of X number of active jobs?
How would I determine the maximum overlap of projects, as well as the average value?
Scenario
Let's say April was the busiest time of the year for projects, and at some point during that month I had 25 jobs active at the same time. What formula can I use to achieve that 25 value.
Also, what formula can I use to determine "on any given day in the year," there is an average of X number of active jobs?