First off, let me give a huge shoutout to my colleague Klaudia for inspiring this post. She put together a dashboard format for a client we work for and I found it to look so sharp that I’ve adopted it for my own uses!

If you are looking for some inspiration for how you can make your Tableau business dashboards more visually intuitive, you’ll want to check this out! I walk through all the design steps in the video below.

Dealing with nulls in Tableau calculations requires a bit of specialized product knowledge. For instance you can’t write IF [Dimension] = NULL THEN “X” END. If you want to reference a null value, you need to use ISNULL. If you want to replace a null value with another value, you can use IFNULL. If you want to replace all nulls with zero, you can use ZN. Check out the video below to learn how these functions work and learn which kinds of use cases they are most helpful for.

I was recently reading the book Principles by Ray Dalio (who founded one of the largest hedge funds in the world). He has an interesting mind and displayed a chart for visualizing data over time series, ranking values against each other. He mentioned that good thinkers are generally able to identify and visualize trends well. His chart looked something like this.

A student in one of my Tableau classes recently told me they were searching for a solution to one of their problems and came across my blog post Month to Date vs. Previous Month to Date in Tableau. Score!

I asked if it solved his problem and he mentioned that his use case was slightly different. Instead of answering the question, “How do month to date sales compare to previous month to date?” he was trying to answer, “How do month to date sales compare to month to date sales for each month from the past year?”

Tableau is optimized to perform date comparisons and calculations relative to a standard calendar. If your organization’s year starts on the first of a month other than January, Tableau can still handle that relatively well. The flexibility breaks down when the calendar year doesn't start on the first of the month and the comparison periods (e.g. semester or trimester) don't align with Tableau's pre-built periods (quarters, months, weeks).