Category Archives: Level of Detail Calcs
One of the best features introduced in Tableau 9.0. The possibilities of analytics and problem solving are unlimited.
-
How to remove duplicate records in Tableau Prep
Posted on May 23, 2018 by Joshua Milligan in All, Calculations, Data Shape & Structure, Level of Detail Calcs, Tableau Prep (Maestro), Tips and Tricks, Uncategorized.One of the questions that comes up quite often is “How do I remove duplicate records in Tableau Prep?” or “How do I dedup data in Tableau Prep?” Some data preparation tools have a specific feature to do this. At first glance, the first version of Tableau Prep doesn’t seem to have this feature. BUT […]
Continue Reading... 3 Comments. -
A Sample Flow in Tableau Prep (Project Maestro)
Posted on February 13, 2018 by Joshua Milligan in All, Data Blending & Joining, Data Shape & Structure, Level of Detail Calcs, Tableau Prep (Maestro).I recently had the privilege of presenting a preview of Tableau’s Project Maestro (now known as Tableau Prep) to the Amazon Tableau User Group. This is not the exact presentation, but is a very similar data flow to the one I demonstrated there. The flow also shows how to replicate a Level of Detail calculation […]
Continue Reading... No Comments. -
Latest Snapshot in Tableau and Tableau Prep (Maestro)
Posted on February 1, 2018 by Joshua Milligan in All, Calculations, Data Blending & Joining, Data Shape & Structure, Level of Detail Calcs, Tableau Prep (Maestro).Often, you’ll have data that looks something like this: Every day, there are new records for projects that give the latest status and count of hours used. Often a project spans multiple days and the status can change and count of hours might go up. But if I want to get the most recent […]
Continue Reading... 3 Comments. -
Periodic Snapshots with Tableau Incremental Refresh
Posted on January 3, 2017 by Joshua Milligan in All, Calculations, Data Blending & Joining, Dates, Level of Detail Calcs.Happy New Year! Even as 2016 was winding down, I found myself with a challenge dealing with time. And I thought I’d share some of my thoughts about a possible approach. Here’s the challenge: You have a database with transactional data, that is data where the rows are inserted, updated and deleted based on events. […]
Continue Reading... No Comments. -
Tweaking Views in Tableau
Posted on February 16, 2016 by Joshua Milligan in All, Calculations, Dashboards, DataViz, Level of Detail Calcs, Storytelling & Commentary.In a previous post I shared how even a small tweak to a dataviz can change the perspective of the data story. The example I gave demonstrated how a view that used absolute time (with date defining the axis) presents a different story and highlights different insights versus a similar view that used relative time […]
Continue Reading... 2 Comments. -
Extending LOD Calcs with Table Calcs
Posted on June 2, 2015 by Joshua Milligan in All, Calculations, Level of Detail Calcs, New Features.I’ve been following with great interest the discussion in the Tableau community surrounding various approaches to using Level of Detail Calculations (LOD calcs) to solve various problems. On the one hand LOD Calcs are often very easy and intuitive. For example, it easy to determine an aggregation at any level of detail: How many unique […]
Continue Reading... 16 Comments. -
Life before Tableau 9 Level of Detail Calculations
Posted on April 24, 2015 by Joshua Milligan in All, Calculations, Data Blending & Joining, Level of Detail Calcs, Storytelling & Commentary.Over the next few weeks, leading up to the Tableau Think Data Thursday presentation (register now!), I’ll take a look at some fun facts about Tableau 9 Level of Detail calculations. Today, let’s take a look at life before LOD calcs: In versions prior to Tableau 9.0, Level of Detail (LOD) calculations were not available. […]
Continue Reading... No Comments. -
My Favorite Tableau 9.0 Feature
Posted on January 14, 2015 by Joshua Milligan in All, Calculations, Level of Detail Calcs, New Features.Tableau 9.0 has moved from alpha to beta and I’m loving it! There are many new features to enjoy: Improved calculation editor Ad-hoc calculations New functions (like regular expressions) Data interpreter and cleanup tools like pivot and split Drag and drop analytics Map Search New selection options (radial, lasso) Responsive tool-tips Formatting for Story Points And […]
Continue Reading... 39 Comments.
Joshua Milligan is a four-time Tableau Zen Master. His passion is training, mentoring, and helping people gain insights and make decisions based on their data through data visualization using Tableau.
He is a principal consultant at Teknion Data Solutions, where he has served clients in numerous industries since 2004.
Joshua served as technical reviewer on several Tableau titles and is the author of the book Learning Tableau.
