A quite common request is to display what the user has selected within a filter. In our today's case what we will do is to show within the header the selected date range plus a warning if the dates have a break in it. That is, if the user selects January, February and April, the... Continue Reading →
A bit about the order of operations – Part 2
Here is the second and concluding part of the mini series on diving into the order of operations based on workout-wednesday 2022 week 15 challenge by Erica Hughes. In Part 1 we rebuilt the solution that was in the challenge but this time our aim is to avoid using hard-encoding the maximum date or storing... Continue Reading →
Maintaining relative values in a tooltip
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 →
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 →
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 →
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 →
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 