Skip to main content


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

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Converting a list report to a summarized report

Updated on April 5, 2022

Analyze the numerical data to discover the number of particular events in the application by converting the list report to a summarized report. For example, you can summarize the total number of user identities in the application.

  1. Run the report that you want to update.
    For more information, see Running a report.
  2. In the upper-right corner, click Edit report.
  3. Click ActionsSummarize.
  4. In the Summarize and Sort section, in the Summarize list, select one of the following methods to summarize the values of each column.
    • To remove the column from the report, select Do not include.
    • To group the summarized values by the values in a column, select GROUP BY.
    • To display the number of rows in the column for each group, select COUNT.
    • To display the number of unique values in the column for each group, select COUNT DISTINCT.
    • To display the highest value in each group, select MAX.
    • To display the lowest value in each group, select MIN.
      Note: You can select one option for each column.
  5. In the Sort list, select one of the following methods to sort the values of each column.
    • To display the values in ascending order, select Lowest to highest.
    • To display the values in descending order, select Highest to lowest.
    • To leave the order without changes, select No sorting.
  6. Optional: To add a column displaying rows count, select the Include a column of row counts check box.
  7. Optional: To expand all group sections when you open the report in the Report Viewer, select the Expand all group sections by default in initial display check box.
  8. To exclude the group headings from the report results, select the Do not display group headings check box.
  9. Convert the list report by clicking Apply changes.

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