Assume you are creating a chart with some bars on it showing absolute sales and the corresponding percentage of the overall value. So, in sample-superstore terms you have four bars, one for each region. When you hover, you want to show the segments that make up that bar. Like this: As can be seen, the … Continue reading Maintaining relative values in a tooltip
Category: Table calculations
Quickie on combining index and sub totals
In case you encounter the problem that you want to number your table by using index and still add a subtotal and thereby run into this here is the workaround: Copy your dimension which you intent to number using the index. In the above example, it is customer name. Put the original customer name to … Continue reading Quickie on combining index and sub totals
Another quickie on aliasing
Have you ever encountered that you were creating BANs (Big (Buttocks) Numbers) and wanted to show sub-segments as well as the total side by side all in one sheet? Let's do an example: Connect to superstore sample data and but segment on columns. Sales goes on Text. Add "Totals" from the Analytics pane This is … Continue reading Another quickie on aliasing
Quartlery year over year comparison when one QRT isn’t fully done yet
Month on Month, Quarter on Quarter or Year on Year comparisons are an absolute standard in many analysis and/or dashboards. Recently the question came up how to do a quarter on quarter analysis on a yearly basis (that is, compare Q1 to Q1) when the current quarter is not yet finished. Understandably, the user wanted … Continue reading Quartlery year over year comparison when one QRT isn’t fully done yet
A quickie on understanding table calculations
It's Christmas, the kids are super tired from the exciting day and I am the only one left awake. What could be a better way to (most likely) conclude the year than to provide another example on table calculations? Today I have nothing new or unexpected, it is just adding to the vast array of … Continue reading A quickie on understanding table calculations
Quickie: Show totals only for one column in a text table but keep all details in the other columns
For today I got a tip which mostly is layout'ish but also somewhat data privacy related The question was how we could get a table like this: to only show Details for in this example the sales but profits should only be shown in the (Sub) Total line. Building on Jeff Shaffer's great blog post … Continue reading Quickie: Show totals only for one column in a text table but keep all details in the other columns
Tableau Adventurer 