Can you re-post the workbook as a .twbx as I don't have access to the .csv data!!
Although this will allow a line (...btw in the next release we should be able to draw lines across panes!) the Month (as green pill) would have to go to the right of measure names, so the bars (for each month) would no longer be next to each other.
When Srikar re-posts the .twbx, I think the data would need to be pivoted (so we get a "real" measure name dimension)...I think!
(...btw in the next release we should be able to draw lines across panes!)
Any idea on the availability & version number?
1 of 1 people found this helpful
Well this is an interesting one...at first I couldn't remember where I'd seen this (thought I might have actually dreamed this one!! - I do dream Tableau!!).
But then I remembered...it was off this post on the (top) of Forums page Tableau 10.2 – New Features in Beta!
where I saw this...
However I've just revisited this and the pop-up of "ticked-off" features has changed...I've asked Ashley to clarify where it went!! (in fact the entire list has changed!)
2 of 2 people found this helpful
Well you certainly like to push the boundaries of what can be done in Tableau!!...but this one is actually (just!) possible. When thinking about how to create in Tableau I always think in terms of Blue and Green Pills (Blue Pills create headers, or split the screen up...panes; and Green an Axis within each Pane). So we have to get creative here, to get Tableau to draw what we want.
So the first thing was I had to reshape the data, so we have a real measure names dimension (that I can access in calculations).
Once I have this, I created 2 calculated fields, so I could isolate Line measures and bar measures
[Value - Bars]
IIF([Measure Name - Dim] = 'Hour' OR [Measure Name - Dim] = 'Plan',[Value],NULL)
[Value - Line]
IIF([Measure Name - Dim] = 'Days',[Value],NULL)
Then the creative bit...how do we plot these side by side...
I create a new date field to act as out x-Axis.
[Measure Name Dim as Value]
CASE [Measure Name - Dim]
WHEN 'Hour' THEN DATE('07/'+ STR(DATEPART('month',[Date])) +'/'+ STR(YEAR([Date])))
WHEN 'Plan' THEN DATE('16/'+ STR(DATEPART('month',[Date])) +'/'+ STR(YEAR([Date])))
WHEN 'Days' THEN DATE('15/'+ STR(DATEPART('month',[Date])) +'/'+ STR(YEAR([Date])))
So hour gets plotted on the 7th, Plan on the 16th (the Bars), and then Days (line) on the 15th.
I can then bring in this field at day level (or just as actual, as we don't have time), and make it green. I then bring in the [Value - Bars] and set the Size to 7
I then bring in the [Value - Line] and set the mark to line...dual Axis them...and voila.
Well nearly. I then did some formatting to only display month, and only display every one month (else the Axis will label every day)
So we're actually plotting by day, but have the illusion of it being by month!!
The reason Tableau isn't set up for this is that it's not a very common (or "best practice") viz. I'd consider showing the Hour and Plan as Lines, and the Days as Bars (although I don't know the exact use case, so it might be completely valid the way you have done it...as they say "you have to know the rules to break them"!!)
Hope that helps
So Donna has cleared this one up Re: Tableau 10.2 – New Features in Beta! (in short "I'm an idiot...still fighting the confirmation bias"!!)
That pop-up is just a link list of the ideas page (and it just happened to have that one at the top of the list!!)...so looks like we're going to have to continue to get nuts with the green-pills for the foreseeable!!
Thank you, Simon.
Will wait and see what Ashley would say.
...maybe this will become a "happy accident", and bump it up the development priorities!!
Hope so :-)
Hi Simon Runc ,
Excellent!! Thank you so much for the quick help. It looks exactly same as my user requirement.
Apart from, it seems the .twbx which you have attached is not the latest one as shown below. could you please re-check and re-post the updated one.
Sorry about that...I've re-attached the final version to the answer. Let me know if it doesn't look like the image I posted