Dot Matrix Tutorial


Facebooktwittergoogle_pluspinterestlinkedinmailFacebooktwittergoogle_pluspinterestlinkedinmail

DotMatrix0

A friend messaged me to asked he could create a grid layout for different visualisations, for example a 3×3 grid. I immediately thought about a Dot Matrix visualisation and how I could create this in Tableau. In this seriously quick tutorial, I will go through the steps to create such a visualisation.

The Data

The data for the example is simple.

DotMatrix1

Yep that is it, create this in Excel and paste it into Tableau.

Calculated Fields

We will create a Path (bin) object by:

  • Right click on Path
  • Go to Create, Bins…
  • In Edit [Path] set the Size of bins to 1
  • Click Ok

DotMatrix2

he Path (bin) will allow us to use a table calculation to create additional data points between 1 and 50.

Note: we are using the Path (bin) to densificate data and give us more points to work with. One thing to make sure of is that you check the Show Missing Values.

We will not create the following Parameter:

DotMatrix2.1

We will now create the following Calculated fields.

Index: We are going to use this to draw the individual points.

DotMatrix3

Columns: This will represent the Columns, the numbers of columns is controlled by the Parameter

DotMatrix4

Rows: This will represent the rows, the numbers of rows controlled by the Parameter

DotMatrix5

Note: I would have loved to use the Floor function but it does not work on Table Calculations. As such, I had to produce a workaround.

Color: This will test the value against total number and colour accordingly,

DotMatrix6

Now that we have our Calculated Fields we are ready to build our worksheet.

The Worksheet

We will now drag our Calculated fields into a new worksheet to create our visualisation.

  • Drag Path (Bin) onto the Details Mark
  • Drag Columns onto Columns
    • Right click on Columns, select Compute Using, select Path (Bin)
  • Drag Rows onto Rows
    • Right click on Rows, select Compute Using, select Path (Bin)
  • Drag Color onto the Color Mark
    • Right click on Color, select Compute Using, select Path (Bin)
  • Click on Color and set the appropriate colours.
  • Change the Mark Type to Circle

You should something like the following:

DotMatrix7

Now, on your own…

  • Remove gridlines and borders
  • Reverse the Rows Axis to put Red on top
  • Hide Headers
  • Play with sizes

And now you should have something like:

DotMatrix0

And that is a wrap. I hope you enjoyed this quick Dot Matrix blog. Do let me know how you get along @thoang1000 or comment below.

 

 

 

 

Facebooktwittergoogle_pluspinterestlinkedinmailFacebooktwittergoogle_pluspinterestlinkedinmail

Toan Hoang

About Toan Hoang

Toan Hoang is a technology enthusiast with a broad understanding and appreciation of most aspects of technology but with a passion for Business Intelligence Solutions and Technologies, Data Management and Web Programming.

Leave a comment

Your email address will not be published. Required fields are marked *