Replace Null Dates With Blanks in Tableau
Missing dates that display as "null" in a Tableau worksheet are an eyesore. Want a quick solution? Check out this video for a couple ideas on how you can turn those nulls in to less obtrusive blanks.
Simple
IF ISNULL([Order Date - With Nulls]) THEN ""
ELSE STR([Order Date - With Nulls])
END
Advanced
IF ISNULL([Order Date - With Nulls]) THEN ""
ELSE
DATENAME('month',[Order Date - With Nulls])
" " + DATENAME('day',[Order Date - With Nulls])
", " + DATENAME('year',[Order Date - With Nulls])
END
Connect with us:
•Book an Office Hour with Eric: https://www.eventbrite.com/e/tableau-...
•Upcoming Tableau Classes: https://www.eventbrite.com/o/onenumbe...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Eric on LinkedIn: / eric-parker-37513249
Resources:
•Example Tableau Workbook: https://public.tableau.com/app/profil...