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 Filters, actions and tooltips

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

Combinging 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 Combinging Row Level Security with Rankings

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

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 Show ALL Details for underlying data points (that are not even in the view yet)

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 Mimicing Excels sumif / Vlookup without data manipulation