Table data options for boxplot visualizations

Type of rounding to use to reach the number of decimals in the Decimal precision field. Options include:- Up UP - Down DOWN - Ceiling CEILING - Floor FLOOR - Half up HALF_UP - Half down HALF_DOWN - Half even HALF_EVEN

Note: Only available when Use custom formatting is true.

The field to group by. For example, in a visualization of incident data grouped by Assignment group, all incidents that belong to Software, Service Desk, and Network are placed in separate groups. If the table contains variables or question fields, you have the option to group by one of them at the end of the list of fields.Note:

• It is not possible to group or stack data by the Tags field, or by certain field types, such as MEDIUMTEXT.
• If you want to group by a field with continuous values, such as date or integer, the values are automatically grouped according to any report ranges that are defined for the data. For more information, see Report ranges.

This selection opens a dialog in which you select additional items that the data in the visualization may be grouped by. The viewer of the visualization can then select which of these items to group the data by. The viewer toggles the visibility of the selector in the visualization's More actions menu. In the additional items dialog, you can set whether this selector is visible by default by toggling Selector visible by default.If you select a value in Group by, that is the default group-by value. You do not have to select a Group by value to specify alternative group-by values. In this case, no default group-by value is used.

Data snapshots indicators support only reference, boolean, and choice fields for alternative group bys.

For more information about setting alternative group-bys for multiple metrics, see Options for time series data visualizations with multiple metrics. For more information about the viewer experience selecting from alternative group-by values, see Select a group-by value in a data visualization as a viewer.

Important:

• Only up to three metrics on one visualization support alternative group-by.
• Alternative group-by does not support data binding on the data source

Sorting options of the main and alternative groups set in Group by. Options include:- Name: Sorts the values alphabetically by field or element name. - Value: Sorts the values numerically or by count. - Element order: If you are grouping by records on the Choice [sys_choice] table, either directly or through a breakdown, this option sorts the groups according to the value of the Sequence field. - Group bucket: Sorts the elements by bucket group, when applicable. Only available for indicator data sources and when the breakdown used for the Group by is based on a bucket group. - Report range: Sorts the table field values by range. Only available for table data sources and when the table field used for the Group by has a report range associated with it.

Note:

• The choices of what to sort by are based on the main, default Group by, if one is defined. This sorting applies to any alternative group-bys if possible. If the sorting criterion selected for the main group-by cannot apply to an alternative group-by (such as sorting by Element order when the alternative group-by is not on the Choice table), sorting for that group-by defaults to Value.
• If no main Group by has been set, but alternative group-bys are defined, you can sort only by Name or Value.
• Sorting is not available for Pareto bar visualizations. Pareto charts are always sorted by value in descending order.

Ascending or descending.Limitations:

• You can only order by the Group By or the Stack by field.
• You can only order by one field. It is not possible to sort by Additional group by fields.