1 Reply Latest reply on Jun 29, 2017 12:16 PM by Ketan Kulkarni

    Time Frame Metrics for Retail Sales

    Danielle Klatke

      We are a data company that works with multiple different Retailers sales data.  We are looking for a way in Tableau to be able to calculate metrics such as Last 4 weeks sales this year vs. Last 4 week sales Previous year.  Last 8 weeks sales, ect.....

      We have tried multiple variations and the issue we are coming across is when these calculations span over 2 different years.  For instance, the first couple weeks of January 2017 and the last few weeks of December 2016.

       

      Any insight is greatly appreciated!