1 of 1 people found this helpful
you can set the Fiscal Year to start from whatever month you choose. You can also change the day a week starts on. By doing this, you won't need to create calculated fields to derive dates - you can just use the built in date functions of Tableau!
Follow the following instructions and you should be on your way!
Hi Jane Crofts, I've never had much luck (or need) to use this, but on that link it says : Note: Date functions do not take account of the configured fiscal year start.
I've attached something similar to what I usually do when playing with fiscal years, but I'm hoping to learn a better method of doing this
193571.twbx 24.9 KB
Thanks for your insight and I guess this way we can compare the multiple years for the FY , but the Fiscal Start year will only allow to choose for the current year not possible for multiple years.
In the attached I see the FY and FQ and the FQ are the quarter numbers, is there any way we will have the quarters like Q1,Q2,Q3,Q4 ....I want to derive Fiscal QTR instead of Fiscal Q.
Also how do we derive the Fiscal week and Fiscal Month from the same approach.
Any ideas on this would be greatly helpful.