Creating a fixed date period filter

lebotlhabanyane
Giga Contributor

I want to create a fixed date period, for example in the attached image, if I choose the last 60 days, that 60 days is as of the current date and changes daily, however if I wanted to choose an exact period, i.e., a previous month, that will change at the end of the current month, there is no such option. Please help, how do I do it?

lebotlhabanyane_0-1709880656154.png

 

5 REPLIES 5

Tsura Andreeva
Mega Sage

you could use this option

 

capture.JPG

 

lebotlhabanyane
Giga Contributor

Hi Tsuro, this doesn't help me set a fixed period that changes after a certain duration. To be more specific, I want to define incentive periods that change every 6 months.

Assuming you are using PA.

What I do is is create a job that only runs once every measurement period - many of our things are based on a four week period, so the job runs once every 28 days.

 

If you are needing to build the data as the period progresses, that can be handled with a "Resolved After 3/25/2024" - this would require tweaking every 6 months which is never fun.

 

What I attempt is to use either the selection criteria at indicator level, or get creative at the Job execution level.

 

Hopefully, one of these options will give you an idea.

Thank you for that idea, I will play around with it and see what I can achieve.