Skip to main content

Report Filtering, Grouping & Custom Properties

Shape an AI report so it answers a specific question — filter to the right contracts, group them so patterns stand out, and add custom properties with the correct output type so you can sort, filter, and drive reminders.

L
Written by Larissa Grabarski Pimentel

Once you know how to build a report, the next step is shaping it — filtering to the right contracts, grouping them so patterns stand out, and adding custom properties that capture exactly the data you care about.

This guide covers the techniques that make reports accurate and easy to work with at scale. If you're new to reports, start with Building AI Reports in Aline first.


Overview

In this article you'll:

  • Learn why columns must be added before you filter

  • Filter documents by label and metadata

  • Collapse multiple exclusions into a single "is none of" filter

  • Create custom properties with the right output type

  • Group by contract type to see your portfolio in segments

  • Save filter views and export to CSV or Excel


Add Your Data Columns Before You Filter

The single most important habit: add every data column (property) you need before you apply filters. If you filter first and add columns later, the AI may not run across the full set of documents, and you can end up with missing or blank values.

💡 Best Practice: Build the report in this order — add your columns, let the AI extract across the whole document set, then filter and sort. This guarantees every contract in view has complete data.


Step 1: Filter Your Documents

Use labels and metadata filters to narrow your report to the contracts you actually want to analyze — for example, a single contract type, a status (Signed, Expired), or a date range.

Filtering by label is the fastest and most reliable way to isolate a group, which is why consistent labeling pays off (see Organizing Documents with Labels & Bulk Labeling).


Step 2: Combine and Simplify Filters

When you're excluding several contract types at once, you don't need a separate filter for each. Collapse them into a single "is none of" filter listing everything you want to leave out. This keeps complex reports readable and easier to adjust later.


Step 3: Create Custom Properties

Beyond the built-in prompts, you can create custom properties to extract or store exactly the field you need. Each property has an output type — text, Boolean (yes/no), date, or multi-select — so the data comes back in a usable, sortable format.

Common examples from real portfolios:

  • An Execution Date property for teams that don't run every contract through a workflow and need a reliable signed date to filter on

  • A numeric Contract Amount property, so you can sort and prioritize by value (for example, surfacing every agreement over $25K)

  • Expiration Date and Auto-Renewal Provision columns to drive renewal tracking and reminders

⚠️ Give date and amount fields the correct output type (date, number) rather than leaving them as text — it's what lets you sort, filter by range, and feed the value into reminders.


Step 4: Group by Contract Type

Grouping arranges your report by a shared value — most often contract type — so you can see your portfolio broken out into meaningful segments and spot outliers quickly.

Combine grouping with filters to answer questions like "show me all vendor agreements expiring next year, grouped by renewal type."


Step 5: Save Your Filter Views

Once a report is filtered and grouped the way you like, save the view so you (and your team) can return to it without rebuilding the filters each time. Saved views are the backbone of recurring processes like quarterly renewal reviews.


Step 6: Export

When you need the data outside Aline, export to CSV or Excel. This is also handy as an intermediate step — for example, exporting a report to build a Playbook from its outputs.


💡 Best Practices

  • Columns before filters, always. It's the difference between a complete report and one with blanks.

  • Filter by label rather than by hand — it's faster and it rewards consistent labeling.

  • Use "is none of" instead of stacking exclusion filters.

  • Set output types deliberately — a date stored as text can't be sorted or used in a reminder.

  • Save the view as soon as a report is right, so quarterly reviews take minutes instead of a rebuild.


📚 Related Articles


❓ Need Help?

Building a report that has to answer a very specific question? Click the Support button in Aline — we can help you structure the columns, filters, and property types before you run it at scale.

Did this answer your question?