Advanced Analytics Access Request Report - Select past X days for CompletionDate

We are on IIQ 8.4

I have configured an Advanced Analytics Access Request report for terminations between 2 dates. If I save this as a scheduled report, is there any way to edit it to look for something like ‘last X days’ instead of between two dates.

So, the report would run weekly and give a result of the Termination requests that completed in the past 7 days.

Thanks for any thoughts!

Hi @chrisk ,

The GridReport requires static date inputs and does not support dynamicdate logic.

Alternative Solutions:

1. Custom Live Report using Filter Data Source:

  • Create a new custom Live Report using the Filter data source.
  • In the report, specify the date range dynamically.
  • This report can then be scheduled to run weekly, and it will always return records from the past 7 days.

2. Scheduled Task with a Rule:

  • Develop a rule that queries termination requests completed in the last X days.
  • Attach this rule to a Run Rule Task.
  • Schedule this task to run weekly.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.