The Tableau blog reposted my Fast Headers for Single Measure Tables post and I got the following question from Pamela Ann in response:
@tableau @jonathandrummey It's so simple! Thanks! Now how do I get a header to stop saying "Year of Year" instead of just "Year"? 🙂
— Pamela Ann (@JustPeachie05) November 20, 2015
Here’s the problem, when using YEAR(Date) on Rows Tableau is automatically inserting the “Year of” for the header:
We could create a calculated field for YEAR([Date]) and then use an Exact Date for the pill, but there’s an even faster way.Using Tableau’s Custom Dates feature we can do that in a few clicks plus typing the name of our new date field:
Thanks again JD for another great insight. My biggest time saver like these has been to set the default number properties for the measures I’m going to be using in a workbook. This saves all the formatting steps I used to have to do in a workbook before I knew that feature existed.