Hi all,

Welcome to another blog. At the end of last year I published a dashboard for Tableau Fringe Festival.

You can view it on Tableau Public using the link under the title above.

What I wanted to achieve with this dashboard is by simply applying a few visual design elements to existing metrics (i.e re arrange the page a little bit, amend typography and colours and balance, but not make huge chart changes or changes to metrics looked at), the user can better understand the visual.

If you’d like to view the original, a print-screen can be found in the version on Tableau Public, else you can find it on the Tableau Accelerators page.

Now, this blog won’t look at whether you believe I have achieved that or not, but I do want to explain how and why I chose to use a colour indicator for filters.

The first thing to realise is that this is an executive summary. Now we all know how much people sadly want to just take a print-screen of a dashboard and send it on. So it seems reasonable enough that they want the filters on the page.

For me this takes up quite a lot of screen real estate where the title is. So is there anything we can do about this? Well yes – we could put all the filters in a show hide me container but then the executive that wants a print-screen of the page won’t know what filters are applied!

So I chose to add in the filter bar as a show hide panel. (Admittedly still taking up real estate on the page) The difference in this case the user now has the ability to hide them.

So a good half way house. We now can claw back some of that screen real estate by having our filters pop out in a show hide me on the page. Allowing the user the flexibility. One other aspect I love about a pop out filter bar is that it doesn’t cover your charts up, meaning from an interactivity perspective it’s less clicks.

That’s all well and good but then we come back to our Exec print screening problem. What is a visual method I can prompt the user if filters are applied?

I ended up with a colour ascii solution. You’ll see that in the footer bar, I prompt the user that an orange circle means that filters are applied.

How can we create this logic?

If a filter has been applied our total number of records will be less than our current value. So I create two calculations. One saying if they are equal, then no filters have been set, so assign it an empty ascii.

I create the reverse logic, if they are not equal then we want a filled ascii circle.

Of course, you can create this as one calculation if you like – but you’ll notice I wanted to also colour the labels separately. Therefore I actually put these two calculations side by side, and colour the false one orange.

By bringing both these calculations onto the details pane of our chart we can now add them into the title as calculations.

This way, when our filter is applied we get an orange circle ascii, and when it isn’t applied we get the empty circle.

One thing to be cautious of with this method is that if you have some sheets that contain filters that you haven’t accounted for, of course your total volumes won’t be equal! This means you would get an orange circle when theoretically…. you have the filters you’re looking at set to all.

For example, take the above where we set our chart to show only the Top 10. We have to add this to context so that it does our fixed calcs after the filter has been applied.

That’s better.

The final thing I wanted to do, was be able to quickly show the user per filter whether the filter was applied or not.

We look to create a new sheet. We create a sheet for EACH of the filters to place next to the filter.

The important thing here is that we make sure to only apply to this sheet the filter of the filter. I.E if we are creating our dot for our booking class filter, we will only want to add the booking class filter onto this sheet. Reason being, we only want the dot to change if this filter count changes, irrespective if we are clicking the other filter counts.

(We have to remember our original true, false has all three calculations in)

I don’t necessarily think people will apply this to business dashboards moving forwards as its quite the faff, but I think the use of colour to draw your eye to the filter really helps quickly identify which filters are being used.

The final touch I added, was a small filter count at the top of the page!

I completely ripped this off Ken Flerlage from about 5 years ago. You can see how the caption sheet summary works in this Tableau Public thread here.

Unfortunately, my filters are in the 10’s or even 100’s so if you go down this method and have more than 3 you end up getting something like ‘Countries: United Kingdom, United States, India +96 more’ which makes sense because they’d not want to print over 100 countries. So I explored a different option of just finding what the distinct count of each filter possibility is, and then a count based on the filters that are applied. I think this gives the user additional context to how much of there dataset has been filtered out.

That’s it for todays thoughts, Let me know if you think it’s overkill or not. I do enjoy playing around with different design ideas.

I can be reached on Linkedin or Twitter.

LOGGING OFF,
CJ