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 →
Highlight and zoom to a point on a map but do not filter
Update: Further below you will find that I suggest applying a factor to one of the calculations. This has been identified to be version related. In Tableau 2021.3 (the version I created my file with) using a buffer on the marks layer results in a lesser zoom extend. In 2021.4 this behaviour is not observed... Continue Reading →
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 →
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 →
