VizWiz

Data Viz Done Right

June 2, 2020

#TableauTipTuesday: How to Compare to a Selected Value with a Set Action

No comments
Set actions are super useful when you want to see how one thing compares to the rest. In this use case, I show you how you can click on a State and have all other States show as a comparison to the selected State.

May 19, 2020

#TableauTipTuesday - Re-Rank Metrics Based on the Overall Rank

No comments
Here's the scenario:
  1. You want to filter a dimension (e.g., State) by the top 10 overall rank. 
  2. You want to re-rank the remaining dimension members (i.e., top 10 States overall) within other metrics. 

For example, Massachusetts is ranked 10th overall and 21st in sales. Once I filter to the overall top 10, the rank should be recalculated to show where Massachusetts ranks in sale amongst the other States in the top 10 overall.

In this tip, I show you how to re-rank the dimensions filter remaining from the overall rank within other metrics.

May 5, 2020

#TableauTipTuesday - How to Add Labels Below All Bar Charts on a Single Worksheet

No comments
By default in Tableau, you cannot have labels below multiple bar charts in the same worksheet. For example, you want month labels below each set of bars in the same worksheet. In this tip, I show you how to work around that by using a dual-axis chart.

April 21, 2020

#TableauTipTuesday: How to Create a Dynamic Reference Band with Set Actions

No comments
Last week when I was teaching DS19, we were coming up with use cases for set actions. We came up with the idea of allowing a user to create their own reference band by lassoing the dates they are interested in. The reference band, via a set action, will then automagically move to the range of dates selected.

Enjoy!

April 13, 2020

#MakeoverMonday: Messi vs. Ronaldo - Who Took the Fewest Minutes to Score?

No comments
I haven't written a blog about Makeover Monday since the end of last year and I want to get back into the habit of blogging, so I'll give a quick review of what could be improved with this week's viz.


What could be improved?

  • Curvy lines don't help you see the exact points of the data. When curved lines are drawn, they render to smooth out the lines, therefore misleading the location of the data along the axis. 
  • Does the data represent each season or matches within a season? Given that I haven't looked at the data yet, the curved lines make me think the latter.
  • Is there a missing title?
  • What does the y-axis represent?
  • It looks like the data might be goals per match, but that would be misleading since they might have substitute appearances? Would goals per minute normalize the data better?

For my alternative, I decided to see who scored goals more often based on the number of minutes played, in other words, how often do they score? Then I wanted to know, season by season, who was better based on that stat.

April 7, 2020

#TableauTipTuesday: How to Use Set Actions to Maintain the Rank of a Dimension Upon Filtering

No comments
One of the drawback of filtering a dimension is that you will lose the rank of a dimension relative to others. This happens because of Tableau's order of operations which dictate that a dimension filter takes effect before a table calculation (rank in this case).

This video shows you how to use Set Actions to filter a dimension while also maintaining the rank.

March 10, 2020

#TableauTipTuesday - How to Use Level of Detail Expressions to Create a Daily Profit KPI

No comments
In this week's tip, I show you how to create a daily KPI view that counts the number of profitable days per month. This is a video that demonstrates my take on example 3 from the Top 15 LOD Expressions blog post on Tableau's website.

February 26, 2020

Visualizing the Geography of TV Stations

No comments
It seems to have been a while since I worked on a personal data analysis/visualization project. The one I'm going to take you through below was inspired by a piece of work I saw by Erin Davis (no contact info to link to). Check out her amazing portfolio on her website.

The piece I wanted to replicate in Tableau is based on her beautiful work Visualizing the Geography of FM Radio. Since she had already done this for radio, I thought I'd try to replicate her work, but with TV stations, that is, the strength and coverage that the broadcast signals from TV stations transmit.

First, I had to prep the data. Fortunately the raw data was easily accessible on the FCC website as are explanations of the fields and how to use them. The FCC also have information about which States fall into which FCC regions. I manually grouped the States into their regions in Tableau (it would have needed to be manually created data anyway).

From there, it was some data prep to get the signal boundaries for each state, ensure they are in the correct State (e.g., some stations that were listed in California actually plotted in other States), then export as a TDE (Hyper files don't work well with polygons).

Here's the Alteryx workflow:


For Tableau, I created a custom color palette based on the color legend on Erin's vizzes, replicated her maps as close as possible, and that's it!


Enjoy!

February 25, 2020

#TableauTipTuesday - Deselect Marks with a Highlight Action

No comments
In this video, I show you how to deselect marks with a highlight action. I take you through two use cases:

  1. Using a set action to click on a region and sort a stacked bar chart based on that region, then use a highlight action to deselect the region selected. 
  2. Using a set action to compare quarterly sales to the sales of a selected quarter. Then use a highlight action to deselect the quarter selected.

Enjoy!

February 11, 2020

#TableauTipTuesday - How to float an entire dashboard and a filter

No comments
Let's say I have a tiled dashboard and I need to float one object, like a filter. When you publish the workbook to Tableau Server, the filter objects can move around, thus messing up your design. To get around this, I float my entire tiled dashboard, then I layer the other floating objects in front of that. When you publish, they will then all move together, thus not altering your design.

In this week's tip, I show you just how to accomplish this.

January 28, 2020

#TableauTipTuesday - How to Create KPIs and Sparklines in a Single Worksheet

No comments
Typically I see people creating one sheet for their KPIs and another for a sparkline. In this tip, I show you how to combine them into a single worksheet. Less worksheets equals less maintenance!

January 14, 2020

#TableauTipTuesday: The Basics of Nested Level of Expressions

No comments
Nested LODs are often a very confusing topic and are usually only needed when you need to aggregate an already aggregated value to a higher level of detail.

In this video, I walk you through the step-by-step method I use for understanding Nested LODs with two examples:

  1. Average Number of Unprofitable Order Per Customer for Each Segment
  2. Average Sales per Ship Mode and Category Across Region