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 →
Keeping a constant number of returned rows
In today's question we will be answering how we can keep the returned results limited to a defined/definable number of rows. That means for example if we say we want only 200 rows to be returned but we have four different segments then each segment should only hold 50 results. If we increase to 300... Continue Reading →
A Quickie on bar chart labelling
For today I have a quick tip on creating a specific labelling for bar charts. This has come out of Workout Wednesday 2021 Week 44. Usually, labels are either at the end of the bar chart (automatic / right), at the end but inside the bar (left) or inside centered (center alignment). But what if... Continue Reading →
Tableau Adventurer 