I have a Pivot that captures
Project, amount of work remaining in days, days remaining in the project (project end date - now() ). I do not have any specific date fields to use in a series.
I need a chart that shows something like a burn down (line chart). Dates till Project end date in X-axis, Amount of work in Y axis, and a line indicating by what date we can burn down all the work. Can this be done without any manual data entry?
Example Data
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
My current pivot table
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Project, amount of work remaining in days, days remaining in the project (project end date - now() ). I do not have any specific date fields to use in a series.
I need a chart that shows something like a burn down (line chart). Dates till Project end date in X-axis, Amount of work in Y axis, and a line indicating by what date we can burn down all the work. Can this be done without any manual data entry?
Example Data
Key | Summary | Assignee | Updated | Remaining Estimate in days | Project | Start Date | End Date | Days remaining |
Item1 | Task 1 | Person A | 11/7/14 | 12 | Project 1 | 11/3/14 | 11/28/14 | 17 |
Item2 | Task 2 | Person B | 11/7/14 | 13 | Project 1 | 11/3/14 | 11/28/14 | 17 |
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
My current pivot table
Row Labels | Max of Days remaining | Sum of Remaining Estimate in days |
11/28/14 | 18 | 25 |
Grand Total | 18 | 25 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>