TabCharts.com

An on-line library for creating different chart types in Tableau



Unit Chart





Tableau Canvas Layout:





Connected dot plot utitlizes dots to represent different values on a graph. The difference is that these dots are connected by lines. It usually has two dimensions on Rows and two similar Measures (dual axis on Columns). Connected dot plot is sometimes called Dumbbell Chart


Data Set: Stacked Unit Chart Dataset



Building an Unit Chart


Opening the Stacked Unit Chart dataset

   Move Country to Rows
   Right-click on Country and create Bin, set the bin size to 1
   Change Marks card to Square. Move Country to Color.

You should now have a view that looks like this:



NOTE: Once you use a bin once on a sheet, it will not default to "Show Missing Values", so will need to change this each time you use the bin for data densification on a new sheet.

Formatting the Color


Normally with all these steps above, we already have a simple unit chart. However, we still can format its color to showcase some comparisons.

   Right-click on Bottom in the Country column and select Hide.
   Right-click on Top in the Country column and select Hide.
   Right-click on the X-Axis at the top and select Remove Header

Create a calculated field:
   Calculated Field: Index
   Formula: index()

Drag Index to Label and you will see Tableau count from 1 to 100 for each row of data, even though there is only one value for Count in each row. The sum(Count) is NULL in all of the other columns. We will leverage this to format our colors.

Create a calculated field:
   Calculated Field: Color
   Formula: isnull(RUNNING_SUM(Sum([Count]))) or index() = Sum([Count])

You should now have a Unit Chart that looks like this:





Related Material:


Data Densification Using Domain Completion and Domain Padding
Bin There, Done That


Return to the TabCharts.com chart gallery