Hi Zach,

One possible option, though I doubt you'll like it, is to manually remove or add the mark labels for the marks. You can right click on the mark and select Mark Label-->Never Show. Then, drag one of the labels to the end of the bar.

Hope this helps a little bit!

-Tracy

Hi Zach,

I have a solution that gets the mark labels in the right place for the columns. It's based on the following process:

1) Finding (or creating) one measure to return a value that can be used as a Gantt Bar, and a second measure to return a value for the label for that Gantt Bar.

2) Making sure that those measures only return one value per bar, for example in your case, only one value per Project.

3) Set up a dual axis chart with the original stacked bar chart measure and the Gantt Bar measure, with the label for the Gantt Bar measure set to the label measure.

In general, table calcs make this pretty straightforward - see Andy Kriebel's post http://vizwiz.blogspot.com/2012/07/tableau-tip-adding-totals-of-2nd.html for an example. However, because the Sample Status field depends on the blended data, and we'd need that to partition the results, when I uncheck "Ignore in Table Calculations" that makes the table calcs break with a "Cannot find a total needed to compute a percentage. The database may have changed or a calculation cannot be completed. Try refreshing your connection or editing the calculation." error.

So, the alternative is to build calculations from the ground up that will generate the correct totals for the # of Samples and # of Records, as well as the % of Total, that will only return one result per Project. I don't have time to go into all the details, the short version is that there are Feeder calcs that return a value for each row in the partition, then the final T Samples and T Records calcs use the LOOKUP() command to effectively partition on the Sample Status and Project. The Compute Using for everything is set to Sample.

In your original views, you had a Grand Total column. I know of ways to hack the Grand Total for text tables and crosstabs, and I tried those and assorted variations on the Grand Total bars and nothing would work, i.e. none of the tests I know of to flag a Grand Total row so we can insert our own values work in the Grand Total bar charts. So, if you really want a Grand Total bar, unless someone has another idea my suggestion is to do the "create two worksheets and a dashboard" trick. For now, what I did was to create a "Total Samples" calc and use that as an extra header.

I created two versions of the worksheet, one that uses a single axis with the Bar mark and on that the labels are not all right-aligned, for the second version I used the dual axis chart I described above and the labels are now all right-aligned.

Cheers,

Jonathan

Hi Zach, I'm glad to help, feel free to ping me anytime! And I agree, pre-joining is the way to go if you're able.