Due date has specific hours, as I see in the data set. But not in Start
Shall we count the hours? Or we can count the days and then multiply the
number by 24 or by 8?
Also, there is no rule about weekends and holidays. Shall we count them or
Please clarify before we can count.
On Mon, Jun 6, 2016 at 11:25 AM, Tracey Dong <email@example.com>
Let's don't worry about hours, weekends and holidays right now. I may work on them later if required.
Right now I need ideas how to make it happen. Main issue: how to distribute the estimate hours to each month between start date and due date? for all IDs.
This tutorial will help you estimate exactly how many IDs there are at a given date
Say, if you have 56 IDs at a given date, then you have 56x8 hours.
Let me know if you have further questions.
I went through the workbook you mentioned. It includes the Year Original as the date dimension. You may calculate the month using Year Original. With my case, I need a date dimension I may use to calculate Month. It's not start date, neither is due date. How do I create Month as x axle?
After pivot, you will have both due date and start date in the same Date column.
Month and Year are part of the date hierarchy.
As long as Date is the dimension, you will have either.
You can expand or collapse Date to have either.
I found a similar post here Re: Divide a value between months
What I did was creating a lookup table manually and then create the date dimension using it. Same as above solution. And it was solved.
Thank you very much!