Help filtering webi

Hello,

I'm new to Webi. I want to create a report that shows only people who haven't submitted an application within 7 days of the due date. Note: the due date is different for everyone. How can I filter this data or conditional format it? I have an application submit flag that's yes or no.

I know how to return the date of 7 days prior, but not sure how to filter out the results to show only individuals who did NOT submit an application between 1 and 7 days prior to the due date.

Example:

• Jim Smith, application due date 10/17/20, application not submitted on or between 10/10/20 - 10/17/20. Include data for that person.
• Nicole Smith, application due date 11/27/20, application not submitted on or between 11/20/20-11/27/20. Include data for that person.

I'd appreciate some help. Thank you in advance!