Summarize data by month for date range
I have an application that lists projects and the effort required for each. I would like to create a chart that summarizes the total of all effort by month using the start and end dates of the project...
Forum Discussion
Yes, you are correct. Sounds easy but it is not. One approach would be to have a set up a bunch of of fields on the Project record such as
[Hours Reqd Current Month]
[Hours Reqd Current Month +1]
[Hours Reqd Current Month +2]
[Hours Reqd Current Month +3]
Then you can have a report which shows the hours required each month relative to the current month. Not sure if that can be turned into a chart, but it will give you a decent report.
[Hours Reqd Current Month]
[Hours Reqd Current Month +1]
[Hours Reqd Current Month +2]
[Hours Reqd Current Month +3]
Then you can have a report which shows the hours required each month relative to the current month. Not sure if that can be turned into a chart, but it will give you a decent report.
Yep. Ironically it was much easier for me when the PMs were forced to estimate effort by month instead of for the entire project in one go. Easier for me, but apparently too hard for them. I am now trying to figure out if I can automate creating monthly effort related records using QB Actions or Automations - and then add/edit/delete effort records if the start or end date changes. Ugh. My head hurts. ;)