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 →
Combining Row Level Security with Rankings
For today I have something straight out of actual day-business. The challenge was to combine row-level-security with rankings. Now the problematic part here is that for ranking we need all the data whereas by definition, row level security in Tableau will filter out all the data that is not within the scope of the allowed... Continue Reading →
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 →
Show ALL Details for underlying data points (that are not even in the view yet)
In today's question from the forums the user asks (I want to) select any point on a graph in dashboard [..] and can sheet 11 [then] show all data from the manufacturers that make up that point? The graph on the dashboard was a profitability line chart by months with Category and Sub-Categories on rows.... Continue Reading →
Mimicing Excels sumif / Vlookup without data manipulation
Update 23 November: As some have noticed, would it not be easier to just do a window_sum(sum[hour_hours])) and compute that by Answer is: yes. The original question was phrased differently with the user asking to also deduct several values which, in retrospect was not what he wanted. All he wanted was to just sum the... Continue Reading →
Tableau Adventurer 