May 25, 2022
#WOW2022 Week 20 - Monthly Sales vs. Target
Resources
- Week 20 Challenge
- My Solution (image below)
May 11, 2022
How to Color BANs by Positive or Negative Change
April 21, 2022
#B2VB - 2022/W4 - Design Some KPIs
Resources:
KPI Samples from Tableau Public:
April 19, 2022
How to Calculate YTD vs. Prior YTD Based on a Selected Date
April 12, 2022
How to Show Data for Only Completed Periods
April 5, 2022
How to Always Sort a Dimension to the Bottom of a Chart
March 31, 2022
#B2VB 2022/W3 - Olympic Medal Tracker
If you're not participating in the Back to Viz Basics community project yet, you should be. It's all about creating effective, simple charts, which is exactly what you need to be able to do before you build anything fancy. This will definitely help you master data visualization best practices.
For week 3, the objective was to build a text table of Olympic medal counts. Sounds simple, but unfortunately, building good looking tables isn't one of Tableau's strengths.
I also started the #WatchMeViz livestreams again. You can find all of them on this playlist. Thank you to those that attended live and asked good questions and left thoughtful comments. Below is the livestream as well as my final viz.
Until next week...
March 29, 2022
How to Create an Alternative to a Merimekko Chart
A Merimekko Chart, also known as a variable width bar chart, is useful for comparing both high-level data and low-level data in the same chart. However, since we have size variables for both the width of the bars AND the height of the bars, comparing different segments of the chart is more challenging than it needs to be. Read more about the problems with Merimekko charts here.
In this example, I show you how to make an alternative to a traditional Merimekko Chart. I show you how to compare both category sales and regions sales within each category at the same time.
This can be easily replicated by simply swapping out the dimensions and updating one LOD calculation. Alternatively, you could use two parameters to allow the user to pick both the high-level and low-level dimensions and a third parameter for the measure to compare.
March 22, 2022
Two Methods for Labeling the Top N Values in a Chart
In this tip I show you how to use the INDEX and RANK functions to label the top N values in a chart. I also explain the difference in how they work, and how the RANK function is simpler to configure.
March 11, 2022
How to Include Multiple Dimensions on the Color Shelf
- You can have more than two dimensions on the color shelf. Simply repeat the steps for adding a second color.
- This only works for dimensions, as I show in the video.
- You do not have to use Sets for this to work; I used that in my example for simplicity.
March 1, 2022
How to Create a Dual Axis Chart with One Dimension and One Measure
This tip comes from a comment from a viewer. They wanted to know how they could build a dual-axis chart based on a single dimension (e.g., Order Date) and a single measure (e.g., Sales). In this tip I show you how to compare the monthly sales for the current year (as a line) to the prior year (as a bar).
February 22, 2022
How to Displays Multiple Measures on Multiple Rows
February 15, 2022
How to Create a Barbell Chart
February 8, 2022
How to Create an Enclosed Dot Plot
February 2, 2022
How to Create a Jitter Plot
In this tip I show you how to create a jitter plot. A jitter plot is very similar to a dot strip plot other than it reduces the overlapping of the data points. The data is plotted like a dot plot and then we use either the RANDOM() or INDEX() functions to spread out the dots.
January 25, 2022
How to Calculate the Distance Between Two Points
January 19, 2022
Social Connectedness in the United States
NOTE: The insights you see in this post are based on an article by The Upshot from September 2018. Some of the insights and use cases demonstrated are the same and are shown in Tableau for demonstration purposes.
----------------------------
When I first saw the map that The Upshot created in How Connected Is Your Community to Everywhere Else in America? I was blow away by the simplicity of the map and how easy it is to understand the relationships of people in the United States via their Facebook friendships. The first thing you need to understand is the metric "Social Connectedness Index". You can access the data I used via the same link.
Here's the formula Facebook uses to calculate the index:
From Facebook:
Social Connectednessi,j measures the relative probability of a Facebook friendship link between a given Facebook user in location i and a user in location j. Put differently, if this measure is twice as large, a Facebook user in i is about twice as likely to be connected with a given Facebook user in j.
In each dataset, we scale the measure to have a fixed maximum value (by dividing the original measure by the maximum and multiplying by 1,000,000,000) and the lowest possible value of 1. We also round the measure to the nearest integer.
I was not able to match the color scale in The Upshot exactly, so instead I used a table calculation that ranks each County in the U.S. compared to the County selected by the user.
Close enough for me!
The data has columns for the State/County of the user and for State/County of the friend. To ensure that I was only looking at friends for the County selected, I used Parameter Actions to filter the user to the County and State selected. The rank calculation then only uses the SCI for the friends.
Now let's look through some of the use cases as described in The Upshot.