Creating an Insight
2 Tasks
15 mins
Beginner
Pega Platform '23
Reporting
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.
Note: The framework of this challenge uses the Constellation architecture of Pega Platform™. To practice this challenge on the Traditional UI architecture, see the Creating an Insight version 8.8 challenge.
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.
Challenge Walkthrough
Detailed Tasks
1 Create a new table-based Insight
- In the Pega instance for the challenge, enter the following credentials:
- In the User name field, enter author@gogoroad.
- In the Password field, enter pega123!.
- In the navigation pane of App Studio, click Explore Data to display the Explore Data landing page.
- Click the 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.
button, and then select
- 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.
- In the Available fields pane, under Assistance Request, click More fields to display additional available fields.
- In the Available fields pane, drag the Case ID field to the Data tab, and then drop it in the Columns section.
- Repeat step 6 for Create date/time, Create operator name, Service type, and Work status fields.
- In the Available fields pane, drag the Work status field to the Data tab, and then drop it in the Groups section.
- In the Available fields pane, drag the Create date/time field to the Data tab, and then drop it in the Filters section.
The system displays the Create date/time dialog box.- In the first Conditional operator list, select on or after.
- In the second Compare with list, select Relative date.
- In the Time period list, select Last.
- In the Value field, enter 30.
- In the Date part list, keep the default value of Day(s).
- Click Submit.
- Click the Save as Insight button to display the Save as Insight window.
- In the Name field, enter Number and status of requests submitted in the last 30 days.
- In the Visibility list, select Public - All users.
- In the Description field, enter Assistance request cases for the past 30 days summarized in a table.
- Click Submit.
2 Create a chart-based Insight
- In the Number and status of requests submitted in the last 30 days Insight, click the Edit button.
- In the Data tab, in the Display as list, select Chart and then select Column.
- In the Available fields pane, under Assistance Request, click More fields to reveal additional available fields.
- In the Available fields pane, drag the Create date/time 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 date/time, then by Work status.
- Click (Year) Create date/time - actions, select Date parts, and then Day to display the number of cases for each day.
- In the Display as list, select Clustered Column to display both the number of cases by Create date/time and by Work status.
- Confirm that the Filters section has a filter called Create date/time >= Last 30 days.
- Click Actions > Save as to display the Save as insight window.
- In the Name field, enter Number and status of requests submitted in the last 30 days.
- In the Visibility list, select Public - All users.
- In the Description field, enter Assistance request cases by day and work status for the past 30 days displayed in a Clustered column chart.
- Click Submit.
Confirm your work
- 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.
- Click Number and status of requests submitted in the last 30 days with the table icon. The table-based Insight is displayed.
- Click Number and status of requests submitted in the last 30 days with the chart icon. The chart-based Insight is displayed.
- Hover over a column to display a tooltip with the number of cases.
- 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:
If you are having problems with your training, please review the Pega Academy Support FAQs.
Want to help us improve this content?