6 Replies Latest reply on May 17, 2016 5:07 PM by khalid norat

    Converting Fiscal Weeks into Months and Calculations

    Jonathon Padron

      Hello Tableau World,

       

      Please see attached. i'm trying to achieve two things. Please see below:

       

      1- create a calculation that will convert the fiscal weeks into months. Our company goes by a 4-4-5 structure. meaning that every third month has five weeks.

       

      2- i have three class delivery i need to sum by month or by every four weeks accept the the last five weeks in the screen shot. for example. ILT i need the sum of the student hours for weeks 1-4, 5-8 and 9-13 all going across. also, need the same for VILT and WBT.

       

      Any help is greatly appreciated.

       

      John