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 →
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 →
Centered dashboards
Here is a quickie on dashboards. Ever encountered that your published workbooks just don't center? Try publishing them with dashboards only selected. Do not publish individual worksheets in addition. For unknown reasons this will cause Tableau to left align instead of center. if you only publish dashboards all will center. That's it. Have a great... Continue Reading →
A quickie on renaming and aliases
In many cases your data source will provide you with rather technical column names, be it dimension or measures. Or, you are usually fine with the naming but for a specific table or chart you just need that slightly changed name label to make it even clearer for your audience. Now what usually you would... Continue Reading →
A quickie on Filters, actions and tooltips
Almost certainly during the course of work with Tableau one will encounter the issue of trying to implement a tooltip and at the same time using a dashboard action or a quick filter that shall also filter the tooltip. Starting with the action filters Unfortunately, we cannot pass through the action as a filter to... Continue Reading →
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 →
