I started to say the same thing April did, but then noticed where 'segments' was on your view. Why do you want to use a continuous line to connect them? Seems to me like you might want 3 different lines, one for each segment that then shows a continuous profit ratio. If so, move the segment pill to the row shelf.
Data Is like Below:
open closed % 4/1/2016 1000 250 25.0% 5/1/2016 900 124 13.8% 6/1/2016 850 122 14.4% 7/1/2016 700 234 33.4% 8/1/2016 900 345 38.3% 9/1/2016 250 15 6.0% 10/1/2016 350 130 37.1% 11/1/2016 102 50 49.0% 12/1/2016 500 450 90.0% 1/1/2017 600 236 39.3% 2/1/2017 234 90 38.5% 3/1/2017 640 278 43.4% 4/1/2017 300 87 29.0%
Please drive me how to get this kind of reports in tableau.
Can you attach a packaged workbook? That would make it easier to assist you. If the values for open and close are coming from the same measure field, you should be able to use a dual axis (one for that field and the other for the % field). If the values for Open and Close are coming from separate measures I think you will run into issues. You may need to pivot those fields in your data source so they come through as a single measure.
A packaged workbook would help me to see more clearly what you're working with.
Attached workbook for your reference.
I don't see the attachment.
Due to some reason, I don't see attachment tab in my reply email. Because of that I edit and uploaded in my original post.
Please Dual Axis Issue Workbook in my original post.
1 of 1 people found this helpful
Because you can't put a continuous date field in front of measure names on the columns shelf, I can't get the exact view we were hoping for.
But maybe you can show it a slightly different way. I'm assuming whatever you're opening and closing here, you would never close more than you opened. If that's true, you might consider this:
1. Remove Measure Names from the columns shelf
2. Make the date pill continuous
You'll get something like this:
3. go to Analysis>Stack Marks> No
You'll get a view like this where the closed are in front of the open
To make it a little more obvious to the viewer that the closed are in front and there is no stacking, you might:
4. Pull measure names from the data pane (not the one currently on color) onto the size card (of the Measure Values Marks Card, not all):
You could then play with the slider to the bars the desired width.
I know this isn't exactly what you wanted, but I'm hoping it might work for you. I would have attached the workbook but it looks like you're using an older version than me.
Thanks Hope. Your right even I did some research on this and it wont possible the way it works in excel. Hope customers will accept this approach.
Thank you, Shinichiro.
It's working perfectly.
In your steps you might forget to mention, we need to switch off Stack Marks in the Analysis tab.
Thank you for following up.