ThereIsLeo
New Member
- Joined
- Jan 31, 2018
- Messages
- 1
Hello, I hope y'all doing well.
I am having a hard time trying to get a pivot graph showing a Plan vs Actual based on counts of ID's and dates.
<tbody>
</tbody>
I need to have a line be represented for Plan and Another for Actual. The way I've worked around this is doing some "duct-tape" workaround, which was to copy the *Actual Date* column, paste it below the last value on *Plan Date* Column, and delete the actual date, and create a new column called PlanVsActuals and Classify the rows by Plan & Actuals.
*Below is duct taped workaround*
<tbody>
</tbody>
Is there a way to create a comparative line graph without having to do this?
I am having a hard time trying to get a pivot graph showing a Plan vs Actual based on counts of ID's and dates.
ID | ID_Name | Status | Plan Date | Actual Date |
1 | UAT | Pass | 1/28/2018 | 1/30/2018 |
2 | SmokeTest | Fail | 1/31/2018 | 1/30/2018 |
3 | YourCodeIsBadTest | Fail | 1/30/2018 | 2/2/2018 |
<tbody>
</tbody>
I need to have a line be represented for Plan and Another for Actual. The way I've worked around this is doing some "duct-tape" workaround, which was to copy the *Actual Date* column, paste it below the last value on *Plan Date* Column, and delete the actual date, and create a new column called PlanVsActuals and Classify the rows by Plan & Actuals.
*Below is duct taped workaround*
ID | ID_Name | Status | Dates | PvA |
1 | UAT | Pass | 1/28/2018 | Plan |
2 | SmokeTest | Fail | 1/31/2018 | Plan |
3 | YourCodeIsBadTest | Fail | 1/30/2018 | Plan |
1 | UAT | Pass | 1/30/2018 | Actual |
2 | SmokeTest | Fail | 1/30/2018 | Actual |
3 | YourCodeIsBadTest | Fail | 2/2/2018 | Actual |
<tbody>
</tbody>
Is there a way to create a comparative line graph without having to do this?