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”