-
1. Re: Problems with Quarter
Jonathan DrummeyMar 1, 2012 3:59 AM (in response to Matt Lee)
1 of 1 people found this helpfulIn 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
-
2. Re: Problems with Quarter
Shawn Wallwork Mar 1, 2012 4:17 AM (in response to Jonathan Drummey)Jonathan, it took me a minute to get the 3-2. Nifty bit of math.
--Shawn
-
3. Re: Problems with Quarter
Matt Lee Mar 1, 2012 9:32 AM (in response to Jonathan Drummey)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.
-
4. Re: Problems with Quarter
Jonathan DrummeyMar 2, 2012 8:24 AM (in response to Shawn Wallwork)
@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).