Forum Discussion

amelia's avatar
amelia
ETL
06-14-2022
Solved

Filtering until last week

Hi! I am creating a pivot table and I currently have all the values populated until the end of this year. However, I would only like to include values up until the previous week, which is a dynamic date. Is there an advanced filter I could use that would help with this? Thank you so much 😄

Dashboards & Reporting

4 Replies

Replies have been turned off for this discussion
    • amelia's avatar
      amelia
      ETL
      06-15-2022

      Thanks Hari! Can I ask, what does the count:1000 part of the filter do? It works, but I just want to understand what the script is doing here 

      • harikm007's avatar
        harikm007
        Data Warehouse
        06-16-2022

        This is to filter last 1000 weeks. If you need to filter 100 weeks including current week, set count as 100 and offset as 0