11 Replies Latest reply: Feb 1, 2016 4:56 AM by Marcus Sommer RSS

    Filter only 4 weeks

    Deepanshu Chamoli

      Kindly guide me in below logic. Is it possible to implement it or not?. If yes please help me

       

      In the dashboard, I want to show only four weeks based on the below situations

       

      1. The Week first day is Friday and last day is Thursday

      2. In the dimension there will be and only four weeks For E.g.

       

      Scenario for this week:

      12/25 - 12/31 - 1 Week

      1/1 - 1/7 - 2 Week

      1/8 - 1/14 - 3 Week

      1/15 - 1/21 - 4 Week

       

      Next Week Scenario:

       

      1/1 - 1/7 - 1 Week

      1/8  - 1/14 - 2 Week

      1/15 - 1/21 - 3 Week

      1/22 - 1/28 - 4 Week

       

      And same goes on.. The current week goes to 4 Week and basis of that the last 3 week calculate

       

      Thanks a lot for your help. Really appreciate it

       

      Thanks

      Deepanshu