Wow, it's been more than a month since I last published something. So it is more than time to get going again. This time, we will do two things: first, revisit workout-wednesday challenge 2022 - Week 15, rebuild it and discuss the challenges related to the order of operations. Then, in Part 2 of this... 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 →
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 →
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 →
Workout Wednesday – 20201 | W21
I thought it was time to deliver on what the blog is promising, i.e. to from time to time provide solutions on Workout Wednesday Challenges and this time we will be looking at an - by now - older challenge dating back to week 21 of 2021.
Tableau Adventurer 