DATASOURCE BASED LOOKUPS IN TABLEAU

a collaborative blog by Ken Flerlage and Klaus Schulte

The Challenge

Last week at work I (Klaus) puzzled my head over an interesting question. I was looking at production orders and production dates and had to calculate differences between production dates:

  • If a production order has consecutive production days (the datediff between the days is 1) then the machine only has to be equipped once.
  • If the datediff between two production days is >1, the machine has to be equipped on each production date.

The Table Calculation-Approach

Continue reading “DATASOURCE BASED LOOKUPS IN TABLEAU”

Building a tournament flow in a single-elimination & exponential tournament structure

Ludovic Tavernier and I have spent quite some time on our collaboration project about the rise of tennis legend Boris Becker. One key element of our viz is something that we have called ‘bump trees‘, a two-layer chart that is combining (horizontal) tournament trees in the first layer with (vertical) bump lines to connect the different tournament trees of a player in the second layer (click the image to play with the interactive version and to read our entire data essay on Tableau Public). Continue reading “Building a tournament flow in a single-elimination & exponential tournament structure”