Forum Discussion
Helper IIIHelp: Total days delay across projects, per month
Hi v-yulgu-msft!
I actually have to explain it better, but I have a dataset and a desktop file to help.
My goal is to show the sum of delayed days per month across projects.
What dictates my X axis is the planned finish date.
Example: The sum of delayed days in April will only be for the projects with an April planned finish date.
The catch is that I want to be able to check the delay of projects, even if they don´t have an actual finish date yet.
Call it an "actual + temporary" delay of projects.
Example 2: Imagine I have a project with a planned finish date of 04/20/18, but the actual finish date is 05/05/18. If I´m checking this report in April, I will see a delay of ~10 days in April (04/30/18 - 04/20/18). When I check the report in May I will see a delay of 15 days in April (05/05/18 - 04/20/18). Remember that my X axis is based on the planned finish date.
Here is a link for the test files:
Below is a pic of how my chart would look like on each month I open my report
Microsoft EmployeeHi karimk,
You said you wanted a line chart to show total ammount of days delayed across all projects, per month, so, you would add "Project" to legend, add "Month" to X-axis, right?
Example: If a project is delayed 10 days by the end of April, then it will be 40 days delayed by the end of May. If it´s finished by June 5th, then the project will register a total delay of 45 days, but the 45 will distributed across each month.
What do you mean "45 will distributed across each month"? Would you please post some dummy data to illustrate this scenario? It would be better to show us your desired output.
Regards,
Yuliana Gu
Helper IIIHi v-yulgu-msft!
I actually have to explain it better, but I have a dataset and a desktop file to help.
My goal is to show the sum of delayed days per month across projects.
What dictates my X axis is the planned finish date.
Example: The sum of delayed days in April will only be for the projects with an April planned finish date.
The catch is that I want to be able to check the delay of projects, even if they don´t have an actual finish date yet.
Call it an "actual + temporary" delay of projects.
Example 2: Imagine I have a project with a planned finish date of 04/20/18, but the actual finish date is 05/05/18. If I´m checking this report in April, I will see a delay of ~10 days in April (04/30/18 - 04/20/18). When I check the report in May I will see a delay of 15 days in April (05/05/18 - 04/20/18). Remember that my X axis is based on the planned finish date.
Here is a link for the test files:
Below is a pic of how my chart would look like on each month I open my report