Heavens, time is flying by, isn't it? Already time for a new blog post. Since I am somewhat short on time these days, I just have a quick one to share. Assume your task is to provide your sales management with an overview that allows them to easily figure out how often it takes a... Continue Reading →
How to select the last day of a dynamic period in Tableau || Let’s have (a word about) date(s) (6/6)
For today, we will do a rather short quickie. Imagine you are tasked with providing a dynamic view that can alter between say weekly, monthly, yearly and you want to show always time-period end values. Create a string parameter and insert there whatever you need, for example the values outlined before. Then, create this calculation:... 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 →
