Skip to main content
LinkedIn
Copied!

Table of Contents

Adding columns to reports

Version:

Only available versions of this content are shown in the dropdown

Extend a report scope by adding a property or a calculation. For example, you can include a calculation that displays the difference in hours, days, or months between two dates of your choice.

  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, and then add columns:

    Choices Actions
    Search for properties to add
    1. In the Data Explorer section, in the search box, enter a property name, and then press Enter.

    2. Drag the property next to an existing report column.

    Display the most suitable properties
    1. In the Data Explorer section, click the Best Bets tab.

    2. Drag the property next to an existing report column.

    Display all available properties
    1. In the Data Explorer section, click the All Matches tab.

    2. Drag the property next to an existing report column.

    Display SQL functions to use
    1. In the Data Explorer section, click the Calculations tab.

    2. Drag the calculation next to an existing report column.

    3. In the Calculation builder dialog box, in the Function input field, press the Down arrow key, and then select the property to calculate.

    4. Click Submit.

  3. In the upper-right corner of the screen, click Done editing.

  • Sorting and grouping columns in list reports

    Make your report more readable and organized by grouping columns and sorting the column values. For example, you can sort and group the report results to present the cases that the user accessed most recently.

Did you find this content helpful?

100% found this useful

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us