Example: Filter Service Contracts by Renewal Notice Dates
This example illustrates how to use the Query Builder on the Expirations dashboard to find service contracts with upcoming renewal notice dates in the next 1 year.
You want to identify service contracts that have upcoming renewal notice dates within the next 1 year to proactively manage vendor relationships and avoid automatic renewals.
- Enable access to dashboards.
- Upload service contracts with renewal notice dates.
- Verify data is available for the relevant time periods.
- Link contract data to the dashboard.
- ClickDashboards.
- Click theExpirationstab.
- ClickEdit Query.We automatically populate the advanced queries withUpcoming Expiration Date in the next 1 yearandRenewal Notice Date in the next 1 yearfilters.
- ClickAdd Section.
- From theGeneral Informationsection, drag and dropContract Typeto the newly added section.
- On theContract Typefilter, selectContains any ofandServices Agreement.
- ClickApply.
We now display only service contracts with upcoming renewal notice dates on the Expirations dashboard, allowing you to focus on relevant agreements for your vendor management.