0 Replies Latest reply on Nov 6, 2018 6:54 AM by Tom Wethern

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

    Tom Wethern

      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.