You can configure custom groups to display in bar charts, donut charts, and pie charts.
Before You Begin
-
To build and deploy reports, your CommCell user account requires a role with the Add Report permission and an association with the CommCell entity.
For more information on users, permissions, and associations, see User Administration and Security - Overview.
Procedure
-
On the Web Console for the Private Metrics Reporting Server, click Reports.
The Worldwide Dashboard appears.
-
To open a report where you have already added a data set, from the navigation pane, click Configuration > Reports, and next to the Report Name under Actions, click Edit.
-
Optional: If your report has multiple pages, click the tab for the page that you want to edit.
-
Configure any of the following chart types:
-
Select the chart, and on the Properties tab, click Fields
A name appears for each field in the chart.
-
To create custom bars, donut pieces, or pie pieces based on string data from the field, configure the chart settings under Custom Groups:
-
Set the Field Name to On, and then click Edit.
-
Click Add Group.
-
In the Group Name box, type a name for the bar or piece.
For example: Multimedia
-
In the Group Values box, type text or a formula that will define the content of the bar or piece.
For example: avi,bmp,gif,jpeg,jpg,mid,mp3,mp4,mpeg,mpg,png,qt,wav,wmv,mov
You can use regular expressions to define the content
-
Click Add Group to define each additional bar that will appear in the chart.
-
To remove a bar or piece, click Delete Group.
-
To include all of your custom groups, even if there is no data to display, set Include custom groups even if there is no data to On.
-
To include all values that are not part of a custom group in a single group titled, "Others," set Include values that are not part of a custom group to On.
-
Click Apply.
-
-
To create custom bars, donut pieces, or pie pieces based on numerical data in the field, configure the chart settings under Custom Groups:
-
Set the Field Name to On, and then click Edit.
-
Click Add Group.
-
In the Group Name box, type a name for the bar or piece.
For example: 0KB to 1MB
-
In the Group Values box, type a formula that will define the content of the bar or piece.
For example: >0 && <=1048576
You can use regular expressions to define the content
-
Click Add Group to define each additional bar that will appear in the chart.
-
To remove a bar or piece, click Delete Group.
-
To include all of your custom groups, even if there is no data to display, set Include custom groups even if there is no data to On.
-
To include all values that are not part of a custom group in a single group titled, "Others," set Include values that are not part of a custom group to On.
-
Click Apply.
-
-
To create custom bars, donut pieces, or pie pieces based on the date and time data in a field, configure the chart settings under Custom Groups:
-
Set the Field Name to On, and then click Edit.
-
Click Add Group.
-
In the Group Name box, type a name for the bar or piece.
For example: 1 Year to 2 Years
-
In the Group Values box, type a formula that will define the content of the bar or piece.
For example: >1y & <2y
You can use regular expressions to define the content
-
Click Add Group to define each additional bar that will appear in the chart.
-
To remove a bar or piece, click Delete Group.
-
To include all of your custom groups, even if there is no data to display, set Include custom groups even if there is no data to On.
-
To include all values that are not part of a custom group in a single group titled, "Others," set Include values that are not part of a custom group to On.
-
Click Apply.
-
-
To save this version of your report specification in the Reports Manager, at the top of the Report Builder page, click Save.
-
To make the report available to end users on the Reports page, at the top of the page, click Deploy.