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:
Cheers!