Configuring Custom Groups in Charts for Build Your Own Reports
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, at the top of the page, click Worldwide Reports > Report Manager
, and on the Reports tab, 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 or piece that will appear in the chart.
- To remove a bar or piece, click Delete Group
.
- Click Apply.
- Set the Field Name to On, and then click Edit
- 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
.
- Click Apply.
- Set the Field Name to On, and then click Edit
- 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
.
- Click Apply.
- Set the Field Name to On, and then click Edit
- 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.
Related Topics