This content has been marked as final.
Show 2 replies
-
1. Re: Can I make this graph in Tableau?
Aaron Anzalone Oct 2, 2012 7:07 AM (in response to Ralph Lindenfeld)How's this (attached)?
I added Reference lines to your axis to get the dotted lines and then added area annotations to get the year number.
-
saveAsImage2.twbx.zip 21.0 KB
-
-
2. Re: Can I make this graph in Tableau?
Ralph Lindenfeld Oct 2, 2012 7:41 AM (in response to Aaron Anzalone)That's really great help, Aaron.
From an automation and updating perspective- is there any way to make the parameters for the reference bars dynamic, so that they appear whenever there's an end of year condition- sort of an IF DATEPART('month', [Date]) = "december" THEN ... ?
I tried to make the area annotation dynamic by using the year of date <YEAR(Date)>, which yields "ALL", but <MONTH(Date)> works, apparently.
Thanks,
RL
-
saveAsImage2.twbx.zip 20.7 KB
-