Skip to main content

Creating an Insight

2 Tasks

15 mins

 Visible to: All users
Beginner Pega Platform '24.2 Reporting User Experience Constellation English

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 request Cases over the last 30 days. Create a table-based Insight and a chart-based Insight that display 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!
Note: Your practice environment may support the completion of multiple challenges. As a result, the configuration shown in the challenge walkthrough may not match your environment exactly.

You must initiate your own Pega instance to complete this Challenge.

Initialization may take up to 5 minutes so please be patient.

Challenge Walkthrough

Detailed Tasks

1 Create a new table-based Insight

  1. In the Pega instance for the challenge, enter the following credentials:
    1. In the User name field, enter author@gogoroad.
    2. In the Password field, enter pega123!.
  2. In the navigation pane of App Studio, click Explore Data to display the Explore Data landing page.
  3. Click the Explore Data button, and then select Assistance Request to display data related to Assistance request Cases. 
    Tip:  If you do not see the Explore Data button in the upper right corner, expand your browser window.
  4. In the Data tab, in the Columns section, to the right of Description, click the More icon, and then click Remove to hide the column.
    Highlighting the More icon for Insight fields.
  5. In the Available fields pane, under Assistance Request, click More fields to display additional available fields.
    Highlighting the More fields button under Available fields pane
  6. In the Available fields pane, drag the Case ID field to the Data tab, and then drop it in the Columns section.
  7. Repeat step 6 for Create datetime, Create operator name, Service type, and Work Status fields.
  8. In the Available fields pane, drag the Work Status field to the Data tab, and then drop it in the Groups section.
  9. In the Available fields pane, drag the Create datetime field to the Data tab, and then drop it in the Filters section.
    The system displays the Create datetime dialog box.
    1. In the first Conditional operator list, select on or after.
    2. In the second Compare with list, select Relative date.
    3. In the Time period list, select Last.
    4. In the Value field, enter 30.
    5. In the Date part list, keep the default value of Day(s).
    6. Click Submit.
      Create datetime
  10. Click the Save as Insight button to display the Save as Insight window.
  11. In the Name field, enter Number and status of requests submitted in the last 30 days.
  12. In the Visibility list, select Public - All users.
  13. In the Description field, enter Assistance request Cases for the past 30 days summarized in a table.
  14. Click Submit.

2 Create a chart-based Insight

  1. In the Number and status of requests submitted in the last 30 days Insight, click the Edit button.
  2. In the Data tab, in the Display as list, select Chart and then select Column.
  3. In the Available fields pane, under Assistance Request, click More fields to reveal additional available fields.
  4. In the Available fields pane, drag the Create datetime field to the Data tab, and then drop it in the Dimensions section above the Work Status field.
    Note: The order of fields matters. In this example, the number of cases is first grouped by Create datetime, then by Work Status.
  5. Click (Year) Create date/time - actions, select Date parts, and then Day to display the number of Cases for each day.
    Dimensions section for an Insight
  6. In the Display as list, select Clustered Column to display both the number of Cases by Create datetime and by Work Status.
    Configure the chart-based insight
  7. Confirm that the Filters section has a filter called Create datetime >= Last 30 days.
  8. Click Actions > Save as to display the Save as insight window.
  9. In the Name field, enter Number and status of requests submitted in the last 30 days.
  10. In the Visibility list, select Public - All users.
  11. In the Description field, enter Assistance request Cases by day and work status for the past 30 days displayed in a Clustered column chart.
  12. Click Submit.

Confirm your work

  1. In the Explore Data landing page, in Insights > Assistance Request, confirm there are two Insights named Number and status of requests submitted in the last 30 days: one displays the chart icon and one displays the table icon.
    Explore Data landing page showing 2 Assistance Request reports
  2. Click Number and status of requests submitted in the last 30 days with the table icon. The table-based Insight is displayed.
    Insight table
  3. Click Number and status of requests submitted in the last 30 days with the chart icon. The chart-based Insight is displayed.
    Insight chart
  4. Hover over a column to display a tooltip with the number of Cases.
  5. Click a column to open a table view with more information about the relevant Cases.

This Challenge is to practice what you learned in the following Module:

Available in the following mission:

Return to mission
If you are having problems with your training, please review the Pega Academy Support FAQs.

Did you find this content helpful?

Yes
No

Want to help us improve this content?
Suggest an edit

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