-
1. Re: Different Fiscal start month for different countries
nikher verma Apr 20, 2018 4:38 AM (in response to Arnab Chaudhury)Hi Arnab Chaudhury ,
You can create a new fiscal year as per your requirements .
Sharing the link ::
https://interworks.com/blog/rcurtis/2017/02/10/tableau-deep-dive-dates-custom-dates/
Please have a look .
-Nikher Verma
-
2. Re: Different Fiscal start month for different countries
Arnab Chaudhury Apr 20, 2018 4:53 AM (in response to nikher verma)Thanks, Nikher for the info.
However, this needs to be dynamic. I need to change the fiscal year start date as per the country selected from filter.
Also, it has to be line chart, with drill up and down feature and the axis need to start from the country fiscal month start .
-
3. Re: Different Fiscal start month for different countries
Sonali chavan Apr 20, 2018 5:08 AM (in response to Arnab Chaudhury)1 of 1 people found this helpfulHello Arnab,
- Duplicate your date field 3 times for each country. Set start of the fiscal year for the respective date field.
e.g. Date_China -> June etc.
- Create one parameter for the country.
- Create 3 different charts for 3 different states using different date fields created earlier. and use hide and show functionality using the parameter.
So finally you will be having 3 charts for 3 countries with the respective start of the fiscal year.
Hope this suffices.
Sonali
-
4. Re: Different Fiscal start month for different countries
Arnab Chaudhury Apr 20, 2018 5:21 AM (in response to Sonali chavan)Hi Sonali,
This is a mock data containing only 3 countries. Actual data contains 150+ counties. Also fiscal start date for each country may change. There is separate table containing the fiscal start date for each country.
-
5. Re: Different Fiscal start month for different countries
Jim DehnerApr 20, 2018 6:20 AM (in response to Arnab Chaudhury)
2 of 2 people found this helpfulGood morning - please see the attached approach
it will return this for example
there are several calculations and I added a date ladder
first the data ladder - is just an excel file with a long list of dates to create a continuous date range that would cover the period
then the Start Date (the month and year of the fiscal month and year in the view
then a filter to limit the output to start at the Fiscal Month start and run for 2 years (this is arbitrary it is just a longer period than in your date year selector
to create the view
Place the Date ladder on the columns
and the filter set to true
I noticed you have 150 countries - you could use a country parameter to select the country and back it up with a calculated field for a filter
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
6. Re: Different Fiscal start month for different countries
Arnab Chaudhury Apr 20, 2018 8:42 PM (in response to Jim Dehner)Hi Jim,
The solution is really helpful. However could you please tell how to implement a drill up and down the date?
year-->quarter-->month
-
7. Re: Different Fiscal start month for different countries
Jim DehnerApr 21, 2018 3:26 AM (in response to Arnab Chaudhury)
1 of 1 people found this helpful -
8. Re: Different Fiscal start month for different countries
Arnab Chaudhury Apr 21, 2018 6:14 AM (in response to Jim Dehner)Hi Jim,
This is of great help!! Could you please share the latest workbook whose screenshot you are showing.
Thanks in advance.