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)
Tag: quickie
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 Quickie on combining index and sub totals
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 Another quickie on aliasing
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 A Quickie on bar chart labelling
Tableau Adventurer 