How to change the date period of saved view automaticaly when change the Start Date of Time

Jialiang
Jialiang
edited February 2023 in Modeling

I have set the Start Date like the following:

Jialiang_0-1621929057561.png

And make a module with all days of April(2021/3/29~2021/5/9) as the following:

Jialiang_1-1621929104294.png

Now,I want to get the data in weekly(like, the first week),so I saved a new view by showing the selected rows of '29 Mar 21' to 'w/c 29 Mar 21',refer to the following:

Jialiang_2-1621929407957.png

 

 

The Question Is:

When I change the Start Date of Time,I want it can change the date period automatically,HOW CAN I DO IT?

 

Operation:

Jialiang_3-1621929607699.png

What I expected:

Jialiang_4-1621929692308.png

 

Thanks

Comments

  • Misbah
    Misbah

    @Jialiang 

     

    Create a SYS TIME module at day level and write the formula

     

    CURRENTPERIODSTART() <= START() AND CURRENTPERIODEND() >= END(). Use this as a filter in your modules.

    Misbah_0-1621933599706.png

    Misbah

  • Vinay VaradarajM
    Vinay VaradarajM

    Hi @Jialiang ,

     

    While @Misbah has already provided you the solution, I would like to add that you need to update 'Current Period' in time settings to make this work.

    I noticed that you are changing the 'Start Date', which could result in loss of data pertaining to previous time. You can instead keep the start date constant for that year, and just update the current period for the time settings filter to work.

     

    Regards,

    vinayvm

Categories