Category: Tableau Calculations

  • Add ‘All’ and more options to a Dynamic Parameter

    , ,

    A couple of years ago, Tableau introduced one of its most highly requested features ever: Dynamic Parameters. This feature made it possible to populate a parameter with values directly from a data source, rather than being limited to static, manually entered values. This works great, but as soon as this was available a new request…

  • Abbreviate long text in Tableau

    , , ,

    When working with text data in Tableau, you’ll often need to clean or reshape strings to better fit your analysis or visual presentation. Abbreviating text is a common challenge when designing dashboards, reports, or any interface where space is limited. Whether you’re working with long product names, category labels, or freeform text fields, overly long…

  • Two Pie Chart Alternatives

    ,

    Pie charts — they seem to be everywhere. They show up in presentations, reports, and in every stockphoto about business meetings. They’re colorful, round, and look super friendly… but despite being one of the most popular chart types, they’re also one of the most frustrating to actually read.

  • Area Funnel chart in Tableau: Visualizing the Drop-Off

    ,

    In the world of digital analytics and customer journeys, not every user makes it to the finish line. Some browse a product, others add it to their cart, but only a fraction complete a purchase. Understanding where users drop off—and how many—can offer crucial insights for optimizing your process. That’s where funnel visualizations come in.…

  • Animated icons in Tableau

    ,

    An old but very efficient way to point the attention to a row in a table is to add a small text-based icon in front of it. A subtle dot in front of a bar can help you tell the story of data.But you might want to use less-subtle ways to highlight data? Animation is…

  • Improve Titles on Small Multiples

    , ,

    Small multiples charts (also known as trellis charts or panel charts) are a great way to visualize trends across different categories while maintaining consistency. They display multiple variations of the same chart, often sharing a common axis, which allows for easier comparison across groups. While effective, these charts can suffer from poor readability if titles…

  • Easier date drop-down in Tableau

    , , ,

    This small tip is on how to add a filter to a dashboard with the current month on top, so it is easier to navigate for users. Not one which will drastically change your dashboard, but a ‘quality of life’ usability tip.

  • Drill Down in Tight Spaces

    , ,

    A different way to make drill down possible/usable in a small sheet. Sometimes you don’t have all the space to do what you want. Or you are almost finished with a dashboard, and suddenly someone mentions: “Wouldn’t it be nice if we could drill down on this chart…” – but the sheet is just too…

  • Deep Cleaning Barcharts – part 2: Punctuated Bar Chart

    , , ,

    [part of the ‘Datafam London 2024 series] In part 1 we took a look at a basic bar chart, and ended with the lollypop chart. A fun chart with one major issue: the dot obfuscates the real datapoint. Punctuated Bar Chart One solution for it the Punctuated Bar Chart:We highlight the end of each bar,…

  • Deep Cleaning Barcharts – part 1: the basics

    , , ,

    [part of the ‘Datafam London 2024 series] On DataFam 2024 in London I gave a presentation / workshop on deep cleaning dashboards. Why cleaning dashboards? Dashboard cleaning is about: Removing, adding , re-arranging, and replacing stuff. In Tableau, it’s about: Table calculations, extra sheets, changing images, talking to users, being critical to yourself, … Is…