2 Replies Latest reply on Jul 27, 2016 2:57 AM by Kor Ai Hui

    How to select whole complete week over month?

    Kor Ai Hui

      Hi all,

       

      When I select certain month and week number, how could I have the whole week data which is not affected by the month.

      For example:

      When I select Month December, and week 49, I would like to have the data in November 30 to be included as well, is it possible?

      Untitled.png

       

      Thank you.

        • 1. Re: How to select whole complete week over month?
          Tom W

          The problem is when you filter specifically on December, you're excluding the underlying data for November 30. In this case, you should just apply your filters based on week numbers if fetching the entire week number is important.

           

          Also, if you didn't need to see sales at a daily level but rather would be OK to see them at a weekly level, you could use a Level of Detail calculation.

          • 2. Re: How to select whole complete week over month?
            Kor Ai Hui

            Thanks for your help. What I did is I apply year and month filter on the worksheet with week column to have related week only, then apply year filter to all other worksheets and last apply action on week to filter other analytics based on week number selection and not affected by the month selection.