Help filtering webi

[former_member698883]

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!

[ayman_salem · Accepted solution]

* Define the following variable:

Flag: =If ([Submit] <> "Yes" Or [Submit Date] > [Due Date] Or DatesBetween([Submit Date];[Due Date];DayPeriod) > 7) Then 1 Else 0

* Then filter the table with "Flag = 1".

...

I hope this gives you an idea of how to do it

[former_member698883 · Accepted solution]

Thanks - I figured it out.