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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]ID_Name[/TD]
[TD]Status[/TD]
[TD]Plan Date[/TD]
[TD]Actual Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]UAT[/TD]
[TD]Pass[/TD]
[TD]1/28/2018[/TD]
[TD]1/30/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]SmokeTest[/TD]
[TD]Fail[/TD]
[TD]1/31/2018[/TD]
[TD]1/30/2018[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]YourCodeIsBadTest[/TD]
[TD]Fail[/TD]
[TD]1/30/2018[/TD]
[TD]2/2/2018[/TD]
[/TR]
</tbody>[/TABLE]
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*
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]ID_Name[/TD]
[TD]Status[/TD]
[TD]Dates[/TD]
[TD]PvA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]UAT[/TD]
[TD]Pass[/TD]
[TD]1/28/2018[/TD]
[TD]Plan[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]SmokeTest[/TD]
[TD]Fail[/TD]
[TD]1/31/2018[/TD]
[TD]Plan[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]YourCodeIsBadTest[/TD]
[TD]Fail[/TD]
[TD]1/30/2018[/TD]
[TD]Plan
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]UAT[/TD]
[TD]Pass[/TD]
[TD]1/30/2018[/TD]
[TD]Actual[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]SmokeTest[/TD]
[TD]Fail[/TD]
[TD]1/30/2018[/TD]
[TD]Actual[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]YourCodeIsBadTest[/TD]
[TD]Fail[/TD]
[TD]2/2/2018[/TD]
[TD]Actual[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]ID_Name[/TD]
[TD]Status[/TD]
[TD]Plan Date[/TD]
[TD]Actual Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]UAT[/TD]
[TD]Pass[/TD]
[TD]1/28/2018[/TD]
[TD]1/30/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]SmokeTest[/TD]
[TD]Fail[/TD]
[TD]1/31/2018[/TD]
[TD]1/30/2018[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]YourCodeIsBadTest[/TD]
[TD]Fail[/TD]
[TD]1/30/2018[/TD]
[TD]2/2/2018[/TD]
[/TR]
</tbody>[/TABLE]
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*
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]ID_Name[/TD]
[TD]Status[/TD]
[TD]Dates[/TD]
[TD]PvA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]UAT[/TD]
[TD]Pass[/TD]
[TD]1/28/2018[/TD]
[TD]Plan[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]SmokeTest[/TD]
[TD]Fail[/TD]
[TD]1/31/2018[/TD]
[TD]Plan[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]YourCodeIsBadTest[/TD]
[TD]Fail[/TD]
[TD]1/30/2018[/TD]
[TD]Plan
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]UAT[/TD]
[TD]Pass[/TD]
[TD]1/30/2018[/TD]
[TD]Actual[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]SmokeTest[/TD]
[TD]Fail[/TD]
[TD]1/30/2018[/TD]
[TD]Actual[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]YourCodeIsBadTest[/TD]
[TD]Fail[/TD]
[TD]2/2/2018[/TD]
[TD]Actual[/TD]
[/TR]
</tbody>[/TABLE]
Is there a way to create a comparative line graph without having to do this?