The main issue is the partitioning needs to be set up correctly for the two table calculations. Click the drop down on the green pills for Box Points and Size of Box Plot and change it from Table (Across) to the Advanced settings used in the original.
Then you'll just need to turn on a border for the Gantt bars and optionally set the fill colour to white.
Thanks Richard. I've managed to get the partitioning set up like you said, but I can't figure out the formatting.
I'm trying this...
1) Right-click on "Box Points" green pill.
2) Choose Format
That brings up the formatting option on the left and shows a tab for Axis and for Pane. I don't see anything related to borders or fill colour for the Gantt bars.
Formatting for marks was cunningly hidden when 6.0 came along - associated with the changes to support combo-charts, I think. I still regularly lose it and have to go hunting around.
To get at the fill and border settings for the Gantt bars you need to select the AGG(Box Points) mark on the marks panel. To change the fill colour, just click in the Color shelf and you can directly select (white in the example sheet). To change the border you need to select the drop-down just to the left of the Color shelf and then the drop-down for the border itself. See yellow highlighting in screen-shots attached.
side note: another way to get the result you want from the originally posted "Sheet 2",
1. For both table calculation pills, change their Compute using from "Table (Across)" to "Customer Name", from their right-click context menu
2. on the Marks card for the Gantt bar, set the sort order of the "Customer Name" pill to sort along the Sum of Sales.
3. perform your formatting
This achieves the same result as Richard's recommended use of the "Advanced" compute using Order along drop-down. Lately I've been trying an approach of trying to avoid using the Advanced dialog. So just just another method.
I didn't even look at it hard enough to see what it was doing, by the way - I was just pointing out how to get it the same as the example you had been given.
I tend to agree with Joe that if you can achieve what you need without using Advanced it can be a bit easier to understand the workbook - though I must admit I've got in the habit of just going straight to the Advanced dialog.
Hello, I have a question about using boxplots. I have had some differences between my percentiles, calculated in Excel using the Percentile function, and the value displayed by Tableau when I add a reference line for percentiles. I am using Tableau Public 6.0. What's interesting is the 50th percentile is 100% correct, but the 25th and 75th percentiles are slightly off, while the 1st and 99th percentiles are farther off.
Here is my sheet with some test data.
Just curious how Tableau is calculating that.
Form http://en.wikipedia.org/wiki/Quantile#Estimating_the_quantiles_of_a_population we can see that Excel uses the Type "R-7, Excel", and from http://www.tableausoftware.com/tcrl/table-calculation%3A-quantile Richard found that Tableau uses Type "R-2, SAS-5".
I think it would be great if we were able to select what percentile function we wanted to use.
Awesome, thanks for the quick reply. I figured it was something reasonsable. I really want to start using Tableau more @ work, but it's hard to dislodge Excel's methods in people's minds.
To get at the fill and border settings for the Gantt bars you need to select the AGG(Box Points) mark on the marks panel.
I can see only "Box Points" fields. How can I enable the aggregation for marks panel.
I see that in the "rows" field I need to have "Box Points" without aggregation.
so how can I have it only for marks panel?