Two quick ideas on reference lines

Here are two quick questions that were raised recently, both regarding the use of reference lines. Question: How to create a custom reference line? In this case, the user wanted to show a median as a reference line but only for values that exceeded a certain threshold. So, in effect he had a bar chart … Continue reading Two quick ideas on reference lines

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 How to select the last day of a dynamic period in Tableau || Let’s have (a word about) date(s) (6/6)

How to do Series Year-over-Year comparisons in Tableau || Let’s have a (word about) date(s) (3/6)

In the last episode we learned how to do a year-over-year comparison when only two years are in the game. However, there may be cases when you want to show multiple years and their year-over-year development in a table - mostly this is something that senior management wants (why the heck do they love tables … Continue reading How to do Series Year-over-Year comparisons in Tableau || Let’s have a (word about) date(s) (3/6)