To visualize and analyze the data specific to an aggregation that you created,
generate a report by providing a condition for the aggregation in the condition
builder.
Before you begin
Role required: pa_admin
Procedure
Navigate to All > Reports > Create New.
In the Data tab, fill in the fields.
Table 1. Data tab fields
Field
Description
Report name
Name of the report.
Source type
Type of the source from which data is fetched. Select Table.
Table
Name of the table for which the aggregation is created. Select the aggregated results table, Aggregated Result [sn_vul_cmn_aggregate_result].
In the condition builder, set the condition for your aggregation for which you want to generate a report.
Table 2. Condition in the condition builder
Part
Description
Field
Select Aggregation.
Operator
Select is.
Value
Name of the aggregation.
In the Data tab, click Next.
In the Types tab, select how you want to visualize the data and click Next.
The supported visualizations are bar chart, pie chart, and heatmap. You
can modify the line graphs and other trends visualisations to make use of the supported visualisations with aggregated result to represent the same data. List view is not supported.
In the Configure tab, fill in the fields.
Field
Description
Group by
Select Grouped by 1 that you selected in the Group By tab for the aggregation.
Stack by
Select Grouped by 2 that you selected in the Group By tab for the aggregation.
Aggregation
Apply Minimum or Maximum function on Value.
In the Style tab, fill in the fields as appropriate and click Run.
For more information about the fields in Configure and Style tabs, see the Creating a report video.
In the condition builder, set the condition for your aggregation for which you want to generate a report and click Run.
The report displays.
To sort the values on the x-axis, select Add sort.
For strings, provide the condition as Grouped by > a-z or z-a to sort the strings in an alphabetical order.
For integer and date data type values, provide the condition as Grouped by.sort > a-z or z-a to sort the values in ascending and descending order respectively.
Figure 1. Sorting integers on X-axis
Select Run.
The integer and date values get sorted on the X-axis.
Click Save to save your report.
The report that is generated for an aggregation displays in the Results tab of the respective Aggregation form.
The Vulnerability Management[Aggregated] dashboard consisting of reports created using the cached
reporting framework is shipped with the base system. To view this dashboard, navigate to All > Performance Analytics > Dashboards > All > Vulnerability Management[Aggregated]. The active aggregations corresponding to the reports in this dashboard are shipped with the base system.