Previous Topic
Group Options
The Group Options dialog appears after you select the Top N button 
above the Area box when the chart type is Heat Map in the Chart Wizard, Insert Chart dialog, Convert to Chart dialog, or To Chart dialog, or in the Bind Data screen of chart in the Web Report Wizard. It helps you to set the sort order of the group values and define the number of the group values that will be displayed in the chart. See the dialog.
Group Order
Specifies in which manner to sort the group values.
- Ascend
Values will be sorted in an ascending order (A, B, C). - Descend
Values will be sorted in a descending order (C, B, A). - No Sort
Values will be sorted in the original order in database.
Group Selection
Specifies the number of group values that will be displayed in the chart.
- Select
Specifies the Select N condition to define the number of the group values that will be displayed.- All
If selected, all group values in the chart will be displayed. - Top N
If selected, specify a number in the field to the right and the first N group values in the chart will be displayed. You can also select a parameter from the drop-down list, which returns an integer, and then specify a value for the parameter when viewing the report to dynamically define the Top N condition. - BottomN
If selected, specify a number in the field to the right and the last N group values in the chart will be displayed. You can also select a parameter from the drop-down list which returns an integer, and then specify a value for the parameter when viewing the report to dynamically define the Bottom N condition.
- All
- Based On
If checked, the group values will be sorted by values of the summary selected with the direction specified. If unchecked, the group values will be sorted by the order specified in the Group Order box of the dialog. - Remaining Groups In
Enabled when Top N or Bottom N is selected from the Select drop-down list. Check this option and then type a character string in the text field to group all the group values beyond the top/bottom N range. - Overall Series
Not supported on group values. - Skip First
If you input a number M in the Skip First text field, the first M group values in the chart will be skipped and the Select N condition will take effect beginning with the M+1 value. The skipped values will be included in the remaining group together with all the group values beyond the top/bottom N range.
OK
Accepts the changes and exits the dialog.
Cancel
Discards the changes and closes the dialog.
Displays the help document about this feature.
Ignores the setting and closes this dialog.
Back to top