1 of 1 people found this helpful
In Tableau, you can create a calculated in the date format using the Qtr field as a basis. Here's one calculation that gets you there, by doing some string manipulation to generate 1/1/2011 for Q1, 4/1/2011 for Q2, etc.
DATE(STR(INT(MID([Qtr],2,1))*3-2) + "/1/" + RIGHT([Qtr],4))
Jonathan, it took me a minute to get the 3-2. Nifty bit of math.
Thanks Jonathan! That was perfect ... thanks so much!!!
I think ideally it's easier to just pull the actual date and then let Tableau convert it to quarters for you.
@Shawn - Thanks! Too much messing around with telecoms billing data in my misspent youth is responsible for that one.
@Matt - You're welcome, and I agree that letting Tableau do the work for dates is very often easier (and faster, too).