I am trying to add a widget to a dashboard that would show change requests created over the past 7 days based on risk. My thinking is that since we can do an "External Widget" that references a filter, I am trying to create a filter that shows only low risk changes created in the past 7 days. The only way I have been able to figure out is to create a filter where the date has to be manually updated each day. Is there a way to do past 7 days so I can use this in a dashboard? I only need the following fields in the widget: Change ID (with link), Title, Short Description, Change Owner Name, and Approval Status Name. Getting the current stage would be nice, but not required.
Thank you for any help you can provide with this.