mvgerma.blogg.se

And there's no love from the automatic column total.īut my calculation really does need a value from the secondary data source. In the calc that uses ATTR(), the only option available for "Total Using" is "Automatic". And the column total works correctly when we do. As you can see, by manually imposing the same logic as an ATTR, IF MIN() = MAX(), the ability to "Total Locally" "Using SUM" magically becomes available. Just to show you what I'm talking about, in the screenshot below I've simplified the calculation to only use values from the primary data source. It's simply because the calculation involves an ATTR( ). Joe me showed two reasons why, because I had managed to stumble upon both of them.īefore we even get into data blending, the first reason why Total Using can be unavailable happens within a single data source. But as we'll see, the crux of my problem was that "Total Using" isn't always available. Here is a quick look at how it works:įor more on Total Using, see here and here. In fact, Tableau has partially implemented this feature already, it's called Total Using. What's required then is a different type of column total, one that computes locally & takes those dimensions into consideration (similar to a table calculation). So, the "automatic" column totals are computed on the server (inside of the data source), and they ignore the dimesions on the rows shelf. I think I like your approach of using SIZE() = 1 better, because I can change the dimensions without changing the calc. This works because Tableau removes the Category dimension when calculating the grand total. IF MIN(Category) MAX(Category) THEN SUM(Sales) END. The other way determine if you're on the grand total row is Notice how Jim Wahl's comment at the bottom of that post also speaks to the very same details we're discussing here: Tableau Quick Tricks - Building a better bar chart This is an important concept, one that plays into the solution and one that Curtis Harris has also hinted at with his clever method for improving the grand totals on a bar chart. And as a result, they explicitly ignore the dimensions on the rows shelf of your worksheet. That is, they are performed on the server (inside of the data source). In many ways, automatic column totals behave like a TOTAL() calculation. This is especially true for automatic totals. The first bit of insight is that column totals can generally be thought of as a semi~separate worksheet. | Tableau Support Community Think of Totals as a ~Separate Sheet

Summarizing the knowledge I received from Joe, I'd like to thank him again for his generosity! All of the packaged workbooks are attached to my forum question, which is here:īlended Boolean Column Totals are Not What They. Stumped by a blending problem where the column total for a blended calculation was zero, I called on my friend Joe Mako.Įxceptionally generous with his time & knowledge, Joe helped me to understand: what at first had seemed to be a simple confusion was actually various roadblocks in Tableau that each require some effort to understand & work around.