Creating a custom filter that updates will filter selected

More or less. What I want to be able to do is if one of my users selects a filter in regards to a certain timeframe i.e. say a week, the widget that has two parts would show the previous week, another example is if they pick a month filter say November, then it would show Octobers numbers. 

So the widget would change based on the date filter they choose would show the previous period. Another example for clarity would be if they show choose 2023 year, then it would show 2022 data. 

Do my examples make sense? 

In my example, following the example provided, I inputted the Days in Date filter but I have not selected a day range.

In the new updated version of Sisense, we have this screen to choose from when filtering for Days in Date. It is not the same as the example, but I assume I can pick the last 30 days in this filter. I added the script and tried picking 30 days, but it still shows the same values compared to the widget that does not have a filter or the script. As shown in the last picture. 

The difference in numbers for the 2nd part of the indicator widget is due to choosing 30 days within the widget in the 2nd formula. 

I have chosen the a weeks timeframe and it is not showing me the previous timeframe. 

Hello DRay,

I did not create a support ticket as my client said that DiffPastPeriod worked for his use case. 

Hi Astroraf,

Yeah, let's get a support ticket opened up and see what they come up with.