10 Replies Latest reply on Jun 6, 2017 9:11 PM by Shinichiro Murakami

# Regarding Fiscal weeks in Tableau for the year 2016.

For 2016 year the Fiscal Week start(FW-01) Should be from 04th January to 09th January. But Tableau Is taking FW-01 start from 1st january itself and showing 01st Jan, 2nd Jan & 3rd Jan as FW-01. See this below picture.

My requirement is to have a Fiscal Week start(FW-01) from 04th January to 10th January  and so on for the year 2016.

Where as for 2015 it is perfectly fine as there are Four days in first week of the month January so tableau is rightly taking it as FW-01 first four days as FW-01.

Can anyone help me out on this one. Its quite urgent for me. Thanks In Advance..

• ###### 1. Re: Regarding Fiscal weeks in Tableau for the year 2016.

Hello Nishant Dwivedi,

This post was originally placed in the Getting Started in the Forums area of the forums.  This is a place we reserve for discussions related to the platform and use of the Community.  Questions related to the use of Tableau Desktop are best to be placed in the Forums.  I have moved this post so that a wider audience may see and respond to the question.

Regards,

Patrick

1 of 1 people found this helpful
• ###### 2. Re: Regarding Fiscal weeks in Tableau for the year 2016.

Pretty limited information as to how your fiscal calendar calculated, but this is my best guess.

I suppose your calendar starts on "Monday".  But not sure how many days can be allowed in last year, seems that 3 days are allowed for sure, but 6 days also allowed?

I mean 1/1~1/6 can be WW53 of last year not.

Anyways here is my formula.

[Fiscal Year]

year(datetrunc('week',[Date],'Monday'))

[Fiscal Week]

int(

(datetrunc('week',[Date],'Monday')+3-

datetrunc('year',datetrunc('week',[Date],'Monday')))

/7

)+1

please refer botom of this post.

Problem by 5-4-4 Calendar ??

Thanks,

Shin

1 of 1 people found this helpful
• ###### 3. Re: Regarding Fiscal weeks in Tableau for the year 2016.

Hi,

I found this. Hope it helps!

And

Good luck!

• ###### 4. Re: Regarding Fiscal weeks in Tableau for the year 2016.

Hi Shinichiro,

Thank you so much for your response.
1) A fiscal week starts on Monday and goes through Saturday.

2) Weeks are measured FW01 to FW52/FW53.

3) FW01 = Week containing the 4th of January for the year 2016.

4) in General FW01 is the first week of the year with 4 or more days in it.

Thanks Again For your time and logic provided.

• ###### 6. Re: Regarding Fiscal weeks in Tableau for the year 2016.

Hi Shinichiro,

Thanks a lot i finally got the output and it was all because of you.

I applied those calculated fields and got the result.

Thanks,

Nishant Dwivedi,

+91-8806577744

• ###### 7. Re: Regarding Fiscal weeks in Tableau for the year 2016.

Sounds good.

BTW, could you mark my answer as correct.

Shin

1 of 1 people found this helpful
• ###### 8. Re: Regarding Fiscal weeks in Tableau for the year 2016.

Hi Shin,

I finally marked it correct after so long..

I am back in the community.. thanks TC

• ###### 9. Re: Regarding Fiscal weeks in Tableau for the year 2016.

Nishant,

Oh Yes, In 8 Months : )

Thank you anyways.

Enjoy the comunity!!

Shin