Category: Quickies

Combine dynamic zone visibility and user permissions to de-clutter your user interface

by Steffen, posted in Level of Detail | LOD, Quickies, User Experience

Here is a quick note on dynamic zone visibility and how you might use it to improve user experience apart from the obvious. So, DZV is new since 2022.3 and you can use it to show and hide for example sheets dynamically based on a condition. Some caveats apply though: Source: https://help.tableau.com/current/online/en-us/dynamic_zone_visibility.htm Showing or hiding … Continue reading Combine dynamic zone visibility and user permissions to de-clutter your user interface

How to select the last day of a dynamic period in Tableau || Let’s have (a word about) date(s) (6/6)

by Steffen, posted in Calculations, Dates & time, Quickies

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 remove null values from date fields || Let’s have a (word about) date(s) (1/6)

by Steffen, posted in Dates & time, Design & Layout, Quickies, User Experience

Assume you have a data source with dates and some other values but some rows in your date column are empty. These will show as null values in Tableau: So, how can we replace these null values with something else, an alias? With any ordinary dimension, you can simply right click and select "edit alias". … Continue reading How to remove null values from date fields || Let’s have a (word about) date(s) (1/6)

Quickie on combining index and sub totals

by Steffen, posted in Quickies, Table calculations

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

by Steffen, posted in Design & Layout, Quickies, Table calculations

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