Hi Ashish, I want the predicted and actual to be line charts, not area charts as noted above.
So unfortunately we can't have 2 sets of measure values, as you'd need here to do this easily! However (as always with Tableau) there are a couple of work arounds...both with Pros/Cons.
So the easy way is to do it with Reference Bands (as shown in the 'Easy Way' tab on the attached). Here we just bring in the 2 measures as lines, and then bring our Upper/Lower bands onto the detail tile, so we can access them in the reference band set up. The Pro is it's easy/quick, the Con being that reference bands are plotted as horizontal/vertical lines...so the effect is a bit blocky (to use the technical term!!)
So the 'Hard Way' is to build up the entire thing using the Area chart type. For this to work we have to 'Stack' the measures, which is the default behavior of the Area Mark. This means that we need to derive the measures we use, so they get plotted at the right place, and then with some deliberate colouring/ordering of those measures we can get the affect you want.
The attached shows the basic method, however you'll need to make a few amendments. I've set the weight to 0.05, so you'll need to remove these from the values above (else the 2nr 0.5s will get stacked an the Top level will be 0.1 too high!). I've only done this on the Upper level, but will need doing to the Actaul/Predicted values too (unless you can live with them being 0.05-0.1 out). The other thing is where Predicted goes below actual (there is no situation of this within this example, but sure it'll happen in your real world version). This means the [Actual - SR] and [Predicted - SR] needs to be handled differently (either adding or taking away from the levels below them, depending on which one is higher - basically a negative number will break the illusion!). The Pro if this method is that it looks much nicer, the Con is that it can get pretty complicated.
I've only got a few mins now so have showed you the basic method, so hopefully you can work it out from here. If not post back and I'll take a more detailed look (might be Thursday now)
sorry i cant open the workbook because your workbook is a newer version. Possible to downgrade it to 9.2.7?
Possible to downgrade it to 9.2.7?...officially not, but I've edited the XML file so this one should open in version 9.0 and above!
Let me know if you are unable to open it