I am trying to calculate the total people working over a two year period. We have lots of contractors and need to create a graph of the total people working for us over the next 2 years.
I have managed to get the months for the next two years without a problem, however trying to get the series is driving me a little crazy. I think its because i need to group not only the start and end dates but summing the total working times, and i just cant get my head around it.
The red line is what i'm trying to achieve.
And this is the data I'm working with. Any ideas on how I should be going about this?
This is what i managed to get working to display the blue line on the above, however i'm not sure why it chose that month, nor why it isn't working.
M is Calc_StartDate2
N is Calc_FinishDate2
G is WorkingTime
Any help/ideas would be greatly received.