This showed me simply what made it from planned and what pushed to stage 2.
I then followed the same process with Committed/Actual data set to determine what was added to stage 1.
This is more or less how I created the graphs above using the sum of hours.
Now how do I combine these visualizations?
So I started with attempting to combine all the data into one query then using an if statement to assign its status(Planned, Committed, Added, Not Committed). I had issues with merging the data as the data sets are not all the same. In the future, that will change but for now, it is where I'm at.
Also when making one query I would only be able to assign committed, not committed and added. Plus I would miss out on the detail of where what came from.
Any tips are greatly appreciated. I don't know how else I should attack this.
This allowed me to make a case for each situation.
I then added a custom column with this if statement:
=if [Literal] = "Planned"
else if [Literal] = "Committed" and [Match] = 1
else if [Literal] = "Committed" and [Match] = 0
else if [Literal] = "Non-Committed" and [Match] = 1
else "Do not include"
This was used as my Column Series.
Which produced the graph i was looking for.
Lastly, I have 2 more items i hope to tackle.
When entering in a line value it does not go across the entirety of the visual?
And how i could go about also splitting the planned column with "Non-Committed' and "Committed"?