It’s time for another Quick Tip in Tableau Desktop!
Have you ever had a pesky data set in Tableau that has Year, Quarter, Month, Day, Minutes as separate fields? This structure can be useful for certain analyses, but a pain-in-the-butt for other analyses that just need a single regular date field.
Have no fear! There is a simple fix for this.
It’s called the MAKEDATE function and it helps you make a date out of the fields you have.
Here’s a quick, soundless video that shows the function:
It’s as simple as this: MAKEDATE(year, month, day). That’s it. Now you have a continuous date field that behaves how you would want your date data to behave.
A Final Note
Tableau can actually “MAKE” a bunch of useful calculated fields that enable tons of analyses. I like to call these the MAKE-it-happen family… mostly because I can’t think of a better name (suggestions are very welcome). They include:
- MAKEDATE
- MAKEDATETIME
- MAKELINE
- MAKEPOINT
- MAKETIME
They’re transformative both literally and figuratively by enabling developers to convert data directly in Tableau. Things like MAKEPOINT and MAKELINE had to be done outside of Tableau back in the “good ole days”. But fortunately, it turns out that we’re in the good ole days right now and they keep getting better! Queue a great The Office quote…
Thanks for reading!