This content has been marked as final.
Show 2 replies
-
1. Re: Change fiscal year start by parameter?
Mark Holtz Oct 12, 2012 8:49 AM (in response to Neil Berkowitz)Hi Neil,
You could certainly accomplish this.
Can you provide a workbook?
In the meantime, you might find this thread helpful:
http://community.tableau.com/thread/119875
Basically, the changes to this would be that
- instead of hard-coding the start month integer (7) into the IF clause, you'd put a parameter (or calculated field based on a parameter)
- and then instead of the THEN or the ELSE values that are hardcoded using 7/1 and 6/30, you could make a calculated field that gives the correct "m/d" text string
Hope this helps!
-
2. Re: Change fiscal year start by parameter?
Neil Berkowitz Oct 12, 2012 3:19 PM (in response to Mark Holtz)I may be missing something basic here. I was hoping there might be a way to set the field property itself from the parameter. I will take a look at your approach. Since our data sources are generally not very large my backup approach is to create a date field for each of the two additional FY start date option, set the FY start property for each, create a parameter and calculated field to hold the selected field.
Thanks for the help.