1 of 1 people found this helpful
Ahhhh Cory we all feel your pain! We've all gone through the "they want" (what they are use to) scenarios as Tableau gets introduced into the corporate culture. Take heart all is not lost, even the most die-hard "we-want-what-we-want" folks finally weaken, bend, and eventually break against the obvious superiority of the fast analysis of Tableau. Read this post from a friend of mine:
As to your specific question, figure out a way to use one of the Superstore sample data sets to cast your question into something we can play with. What you're trying to do looks/sounds doable, so don't give up.
1 of 1 people found this helpful
Another angle to use to pushback is that it's not visual best practices. A review of authors like Stephen Few and it's apparent that a chart like that should not exist and for good reason.
Part of what Tableau has done is build in best practices that are based on science, on the understanding of human visual cognition. I would hope that Tableau would never add a "feature" like what your clients want to see. Regardless, if you can mockup a .twbx and post it, a member of the Tableau Community will probably try to finagle a way to obtain that order of values.
Understanding human, visual perception:
Great for contemporary dashboard design:
I second what Shawn & Phillip said. "This is how we've always done it." is not a particularly good argument for keeping something in place. You could start a conversation with something like, "Since we're implementing new software with new capabilities, this is a good time to review the questions you are asking of your data and whether the visualizations you've been using are answering those questions in the most effective way."
Then you could point out in that screenshot, the user has to look at two different X,Y coordinates to find the ends of one bar and the grand total bar, and hold them both in mind to do a comparison. Whereas with a reference line they can see that on the same Y coordinate, just two X coordinates, and then talk about the Gestalt theories of perception. Or maybe they are looking for some sort of comparison to average, in which case another visualization might do the job better. Personally, I'm a big fan of a single-axis dot plot (which can be turned into a box plot if need be) for an overview of individual vs. group performance:
Or maybe they are looking for a ranking? Tableau's INDEX() and RANK_*() functions could do the job there. There are lots of directions this could go.
That aside, one way you likely could get the results you want is to increase the dimensionality of your data so there is an extra dimension that can distinguish between the Grand Total and everything else. I used the UNION approach from Customizing Grand Totals – Part 3 | Drawing with Numbers (actually, I just downloaded the workbook and created a new worksheet) and just sorted the view so the Grand Total is now in the middle of the view.
The nice part about this is that the view can be filtered any which way and still return accurate results because the data that goes into the Grand Total is a full duplicate of the data used for the rest of the marks. However, if you are using table calcs to generate the %, or a data blend, then you may need to put in some extra effort to make sure the results are accurate.