Antichaos

Tableau, Data Analyse & Visualisatie

Tableau

How to Visualize High-Value Metrics in Tableau Without Starting at Zero

· ·

Every time you publish a chart that doesn’t start at zero, someone will appear in the comments accusing you of misleading your audience. But the truth is simple: not every dataset lives anywhere near zero.

When working with high-value metrics – like atmospheric pressure, energy usage, or financial KPIs – starting a chart at zero often flattens the trend and hides important variation. Simply removing zero can help, but it can also exaggerate small fluctuations, making lines appear more dramatic than they really are. In this guide, I’ll show how to visualize high-baseline data in Tableau using dynamic axis adjustments, reference lines, and buffer zones to create accurate, readable, and visually balanced charts.

[Read more…] about How to Visualize High-Value Metrics in Tableau Without Starting at Zero

Why is COUNTD so slow – and how can I fix this?

· ·

When you start tuning a Tableau dashboard or SQL query for performance, one thing jumps out quickly: COUNTD can slow things down.

The count-distinct is an extremely useful function which looks simple on the surface, but under the hood it forces the engine to do extra work that adds up fast. Understanding why this happens – and what alternatives you can use – makes a big difference in keeping your dashboards responsive.

[Read more…] about Why is COUNTD so slow – and how can I fix this?

Visualizing ‘Dynamic’ Data using a Sine Wave

· ·

Recently I ran into a small but surprisingly tricky problem: how do you visualize something that’s in progress? A standard bar chart works usually perfectly for completed values, but what about the final bar isn’t finished yet because e.g. the year isn’t finished yet,

Fading it out, changing the shape or adding a label like “in progress” didn’t feel right. I wanted something that instantly communicates “this is still ongoing”.

Inspired by how Spotify shows an ongoing song I started experimenting with using a sine wave to bring that bar alive. Instead of a static column, the last bar gently oscillates – hinting that it’s active, not finished.

In this post, I’ll walk through how to create this effect in Tableau step by step.
If you don’t need an ‘in progress’ viz, you can always use it for something else….

[Read more…] about Visualizing ‘Dynamic’ Data using a Sine Wave

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 came up: adding manual values to the list – especially the ‘All’ value.

[Read more…] about Add ‘All’ and more options to a Dynamic Parameter

Tableau Container Art – 4 examples of formatting dashboards without images

· ·

Tableau containers don’t exactly have the best reputation. Most people either ignore them or wrestle with them. But once you actually get along with containers (and their friends: borders, background colors, and padding), they turn into your dashboard’s interior designers.

No images were used during the making of these dashboard elements!

In this post, I’ll show you four small but powerful ways to use the Tableau containers to make your dashboards look sharper, cleaner, and maybe even a little more fun.

[Read more…] about Tableau Container Art – 4 examples of formatting dashboards without images