Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Adding filter conditions

Updated on October 29, 2021

Decide what data you want to present in your reports by adding filter conditions that provide options to display only relevant information. For example, you can filter a report to display sales from a specific year, to analyze purchase tendencies over time.

By using Report Editor, you can create filter conditions that use properties or calculations to filter data. For more information, see Data Explorer.
  1. Run the report that you want to update.
    For more information, see Running a report.
  2. In the upper-right corner of the screen, click Edit report.
  3. In the Data Explorer section, add a filter condition:
    ChoicesActions
    Add a function to the filter condition
    1. From the Calculations tab, drag a specific function to the Drop column to add filter section.
    2. In the Calculation builder dialog box, in the Function input field, press the Down arrow key, and then select a property to calculate.
      Note: Some functions require more than one input property, so more Function input fields are available.
    3. Click Submit.
    4. In the Edit filter section, in the Function name list of operators, select a relational operator for the filter condition.
    5. In the Function name box, press the Down arrow key, and then select a property to compare with your function.
      For example, you can use the Older than n days function to filter the report to display cases that remain open for a specific period of time.
    Add a property to the filter condition
    1. From the Best Bets or All Matches tabs, drag a specific property to the Drop column to add filter section.
      For more information on Data Explorer tabs, see Data Explorer.
    2. In the Edit filter section, in the Filter condition name list of operators, select a relational operator for the filter condition.
    3. In the Filter condition name box, enter specific value, or press the Down arrow key, and then select a property to compare with your property.
    4. Optional: To add a function with which the system compares your property, click Calculation Builder, and specify the function.
      For example, you can use the Day of the week function to filter the report to display all resolved cases on a particular day of the week.
  4. Optional: To change the name of the filter condition that is visible in the Report Viewer and the Report Editor, in the Filter Caption field, enter a new name.
  5. Optional: To use a null comparison value if a comparison value is not specified, select the Use null if empty check box.
  6. Optional: To apply a case insensitive comparison, select the Ignore case check box.
  7. Add the filter condition by clicking Apply changes.
For example: The following visualization presents how to apply two filters that restrict the results to include resolved assignments that are created date prior to 2011-11-19.
Applying filters in summarized report
  • Editing filter conditions

    Customize the filter conditions to display specific information in the report. For example, you can filter the report to display a list of user IDs that contains the division ID.

  • Editing filter logic

    Customize a report to display only data that is relevant to your needs by managing how the report filters information.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us