1 Reply Latest reply on Oct 7, 2016 9:23 AM by Norbert Maijoor

    Creating a previous week dimension?

    William Mohan

      Hi all,

       

      I'm trying to create a dimension which automatically calculates the financial week of the previous day.

       

      I currently have my dashboard connected to two seperate data sources, using the Google Analytics API and an Excel document with merges the date to provide me with information on the fiscal year. (Example below)

       

      What i want to do is create a filter for my dashboard so that it only reports back data for the previous days financial week.

       

      Any help on this would be great,

       

      Thanks,

       

      Billy

       

      Fiscal year lookup

          

      DateFinancial WeekFinancial MonthFinancial Year
      01/08/20161August2017
      02/08/20161August2017
      03/08/20161August2017
      04/08/20161August2017
      05/08/20161August2017
      06/08/20161August2017
      07/08/20161August2017
      08/08/20162August2017
      09/08/20162August2017
      10/08/20162August2017
      11/08/20162August2017
      12/08/20162August2017
      13/08/20162August2017
      14/08/20162August2017
      15/08/20163August2017