Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filter last x weeks

Hi all! I was wondering how to filter my x-axis in order to have only the last 10 weeks. 

 

As you can see below by default it shows all the 52 weeks of the year, and it's very ugly to watch.

I tryed to use an advance filter, but it only permitt to enter number and not formulas.

Sorry if it is a dumb question and thanks!

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI- if you make a date slicer and select "Relative" as your slice type you select however many weeks, days, etc you want and it is dynamice to the data 

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI- if you make a date slicer and select "Relative" as your slice type you select however many weeks, days, etc you want and it is dynamice to the data 

     

  • Thejeswar's avatar
    Thejeswar
    Super User
    8 years ago

    Hi Anonymous,

    You can restrict the last 10 weeks using TOP N Filter as shown in the below image

     

     

    The Top visual shows the data for all 52 weeks, while the bottom visual shows only the last 10 weeks

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Thejeswar, thanks for the reply,

      this is not exactly what I looking for, because I meant last 10 weeks starting from now, for example:

      today we are in week 34, I want to show data from week 24 to week 34.

      • Thejeswar's avatar
        Thejeswar
        Super User
        8 years ago

        Hi,

        If you are having only 34 weeks data with you, filtering TOP 10 is still going to give last 10 weeks which is from 25 to 34 weeks.