Skip to main content

Creating a custom business report

Archived

4 Tasks

15 mins

Visible to: All users
Beginner Pega Platform Reporting English
This content is now archived and is no longer updated. Progress is not calculated. Pega Cloud instances are disabled, and badges are no longer awarded. Click here to continue your progress in the latest version.

Scenario

Stakeholders would like to know the number of cases that have been requested over the past month. You have been asked to define a report to track the status of Assistance requests over the last 30 days. Create a report category for Assistance request cases, then create a report definition in the Assistance request category that displays the number and status of requests submitted in the past 30 days.

Note: Before you begin, generate 10-15 case instances with varying case statuses.

The following table provides the credentials you need to complete the challenge.

Role User name Password
Application Developer author@gogoroad pega123!

Challenge Walkthrough

Detailed Tasks

1 Create a public category for report definitions

  1. In the Case Manager portal, click Reports to open the Report Browser.
  2. In the Report Browser, from the Actions menu, click Manage Categories.
  3. Click New category to display the Create new category dialog box.
  4. In the Create new category dialog box, in the Category name field, enter AssistanceRequestReports to name the report category.
  5. In the Category description field, enter Reports related to Assistance request cases to describe the purpose of the category.
  6. Confirm that the Category type is set to Public.
    Create new category dialog
  7. Click Submit to dismiss the dialog box and create the report category.

2 Create a report to display the number and status of requests submitted in the past 30 days

  1. Click Back to reports to return to the Report Browser.
  2. In the Report Browser, click New report to display the Create new report dialog box.
  3. In the Create new report dialog box, from the Case type drop-down, select Assistance Request to display only Assistance request cases in the report results.
  4. From the Report type drop-down, select Summary or Chart to create a summary report.
    Create new report dialog
  5. Click Submit to create the report and display the Report Editor.
  6. In the Data Explorer pane, click the Label field.
  7. Drag the Label field into the columns in the Report Editor by positioning the pointer to the left of the Entered on column to add the Label column as the first column in the report.
    Report Editor with new Label column
  8. In the Filter section of the Report Editor, click Created in Last 7 Days to open the Edit filter window. 
  9. In the Edit filter window, click Select values to display the Select values dialog box to select the time period used in the filter.
  10. In the Select values dialog box, click Last 30 Days to change the comparison in the report filter.
  11. Click Submit to complete the configuration of the filter and return to the Edit filter window.
  12. In the Edit filter window, in the Filter Caption field, enter Created In Last 30 Days to provide a descriptive label for the filter.
    Edit a reporting filter
  13. Click Apply changes to complete the configuration of the filter and return to the Report Editor.
  14. To the right of the Unresolved Case link, click the X icon to remove the filter from the report.

3 Add a clustered column chart to the report

  1. Click Add chart to display a window to create a chart for the report.
  2. In the window, click the Column icon and select Clustered to create a clustered column chart.
    Add a clustered column chart to a business report
  3. From the Available columns list, click Total and drag the pointer into the Drop Aggregate column here drop zone to add the column to the Y-Axis of the chart.
  4. From the Available columns list, click Entered on and drag the cursor into the Drop Group By column here drop zone to add the column to the X-Axis of the chart.
  5. From the Available columns list, click Status and drag the cursor into the Drop Any column here drop zone to add the column to the chart.
    Clustered column chart configuration
  6. Click Apply changes to complete the configuration of the chart and return to the Report Editor. The Report Editor displays a preview of the report.
    Report preview with simulated data
    Tip: The Report Editor provides a preview of the report using actual case data. If you have not created any cases, click the Simulated data switch to display simulated data in the report preview.
  7. Click Done editing to complete the configuration of the report and display the Save report as dialog box.
  8. In the Save report as dialog box, in the Title field, enter Number and status of requests submitted in the past 30 days.
  9. In the Description field, enter Reports on the number and status of requests submitted in the past 30 days in a summary report with a chart to describe the report for users.
  10. From the Category drop-down, select Reports related to Assistance request cases to assign the report to the public category you created.
    Save report as window
  11. Click Submit to complete the configuration of the report and view the report results.
  12. In the upper-right corner of the report, click the icon to close the report and return to the Report Browser. The report is displayed as a tile in the Report Browser.
    Report tile in the Report Browser

4 Verify your work

  1. In the Case Manager portal, in the Report Browser, click the Number and status of requests submitted in the past 30 days tile to open the report. The report is displayed with results similar to the following example.
    Report preview with real data
  2. In the upper-right corner of the report, click the X icon to close the report and return to the Report Browser.


Available in the following mission:

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

Pega Academy 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