Tableau Tip: Watch Out for Misleading Average Lines!

Tableau’s Analytics pane allows you to slap an average line onto your view. Drag, drop, done?

Not quite. In this blog, I will show you an example of when the average line Tableau creates for you may not be doing what you think it does.

 

Let’s start

So Figure 1 below shows a vertical bar chart with the height of each bar indicating the number of customers that fall into each number of orders bucket. For example, 134 customers have ordered 5 times; 1 customer has ordered 17 times.

 

Fig 1. A vertical bar chart showing how many orders customers have

 

Click to keep reading!

Tableau Tip: Stop Your Viz In Tooltips From Being Filtered

For Dashboard Week Day 4, we looked at Seattle cycling data (see my blog here). I decided to incorporate Viz in Tooltips to enhance my infographic (Tableau Public here) and give the reader more context (see Figure 1).

Now I don’t often use Viz in Tooltips because I’ve always had issues with filtering, this was again true for this viz. This issue is when the filters in the parent sheet applies to the tooltip sheet. I want my tooltip sheet to be static and unaffected by the filters in the parent sheet but for some reason, my tooltip sheet kept being filtered. In this post, I go over how to overcome this common Viz in Tooltip issue.

 

seattle tooltip
Fig 1. Viz in Tooltip in my Seattle cycling viz

 

Click to keep reading!