Examples for filter adjustments
If a report subscription is created and the report uses the time period filter (starting and end date), then the dates are newly set at each report creation for the subscription.
You can enter in the area “Filter adjustments” a reference value for the time period filter (in the settings of the subscription of favorites). Via the reference value and the values of the date filters the delta value (see table) is calculated. This value will be combined with the execution date of the subscription. Thus the time period filter automatically adjusts.
Furthermore you can leave the filter “Start date” fixed in a value in the report filters. Then this value won’t be adjusted regarding the execution date. The time period, which is used in the report, will grow with each execution of the subscription.
You find here now some examples of report subscriptions with various configurations, which are performed once a month:
|Example||Star-ting date filter||End date filter||Sub-scrip- tion Re-ference value||Delta days star-ting date||Delta days end date||Sup-press star-ting date filter||To-do date||Star-ting date filter on to do||End date filter on to do|
|The last 30 days since execution||06/01/2019||06/30/2019||07/01/2019||-30||-1||No||08/01/2019||07/02/2019||07/31/2019|
|The last 30 days since execution||06/01/2019||06/30/2019||07/01/2019||-30||-1||No||09/01/2019||08/02/2019||08/31/2019|
|The last 30 days since execution||06/01/2019||06/30/2019||07/01/2019||-30||-1||No||10/01/2019||09/01/2019||09/30/2019|
|The last 30 days since execution||06/01/2019||06/30/2019||07/01/2019||-30||-1||No||11/01/2019||10/02/2019||10/31/2019|
|The next 30 days since execution||06/01/2019||06/30/2019||06/01/2019||0||30||No||08/01/2019||08/01/2019||08/30/2019|
|The next 30 days since execution||06/01/2019||06/30/2019||06/01/2019||0||30||No||09/01/2019||09/01/2019||09/30/2019|
|The next 30 days since (execution plus 31 days)||06/01/2019||06/30/2019||05/01/2019||+31||+60||No||08/01/2019||09/01/2019||09/30/2019|
|The next 30 days since (execution plus 31 days)||06/01/2019||06/30/2019||05/01/2019||+31||+60||No||09/01/2019||10/02/2019||10/31/2019|
|Eva-luate since June 1st||06/01/2019||06/30/2019||07/01/2019||-30||-1||Yes||07/01/2019||06/01/2019||06/30/2019|
|Eva-luate since June 1st||06/01/2019||06/30/2019||07/01/2019||-30||-1||Yes||08/01/2019||06/01/2019||07/31/2019|
|Eva-luate since June 1st||06/01/2019||06/30/2019||07/01/2019||-30||-1||Yes||09/01/2019||06/01/2019||08/31/2019|