2 Replies Latest reply on Apr 15, 2019 12:29 PM by Tom Wethern

# Using Weekly Retail Calendar 4-5-4 National Retail Federation (Calc Help)

Hello,

Workbook attached is 2018.3

I am looking for some assistance with a dynamic calculation using a weekly retail calendar.  I am using the 4-5-4 National Retail Federation retail calendar (i.e. week 1 is in Feb. and week 52 (or 53) is in Jan).

I would love some help with 2 calculated fields that deal with this weekly info.  I am not well versed in Level of Detail and not well versed in Min/Max (thinking this may be involved here).  Not to mention, I am just getting up to speed with calendar settings in Tableau.

I intend to update my data source weekly with previous weeks sales information.  Thus I would like my calculations to be dynamic.

Current 52 Weeks Sales \$ vs. Previous 52 Weeks Sales \$  (i.e. 52 weeks ending 2018 week 37 VS. 52 weeks ending 2017 week 37)

26 Weeks vs Year Ago 26 Weeks.  (i.e. 26 weeks ending 2018 week 37 vs. 26 weeks ending 2017 week 37)    (Not Previous 26 weeks)

In the end, I am looking to create 4 periods of comparison to view units and dollars:

52 wks vs Previous 52 weeks (i.e. 52 weeks ending week 37 vs. same period ending 2017)

26 weeks vs same period year ago  (i.e. 26 weeks ending week 37 vs same period in 2017)

13 weeks vs same period year ago (i.e. 13 weeks ending week 37 vs same period in 2017)

4 weeks vs same period year ago (i.e. 4 weeks ending week 37 vs same period in 2017)

Not sure why my worksheet 1 starts with “week 2” – probably something to do with 53 weeks????  It shows data through week 38 in 2018 when actually the data is through week 37.

I really appreciate any help.  I have attached the packaged workbook – first time post here, hope I have done everything correctly.

Thanks again for any help.

• ###### 1. Re: Using Weekly Retail Calendar 4-5-4 National Retail Federation (Calc Help)

Hello Tom,

There are a few different resources and examples of these sorts of comparisons in the forums.

FAQ:  To Date Calculations and the video and associated workbooks from  Think Data Thursday: Dating Rody that are found here - Current vs Previous Period to Date Comparison

These are great examples that should help you make the sorts of visualizations mentioned.

Patrick

2 of 2 people found this helpful
• ###### 2. Re: Using Weekly Retail Calendar 4-5-4 National Retail Federation (Calc Help)

Realized I never replied.  Thank you very much for your help.  Useful!