Making the world a better place by helping people understand their data.

Month: October 2017

Data Cleaner for Dates in Tableau

Data Cleaner for Dates in Tableau

A formula I’m working on to clean different types of dates in a calculated field. I did this initially for Ancestry.com data, it’s not perfect, a work in progress. date( IF [Oxg Birth Date] = null then null ELSE IF len([Oxg Birth Date]) = 4 THEN […]