Table data options for Pareto bar visualizations

You have selected a Table data source in Create a horizontal or vertical bar data visualization.

Note: For pareto visualizations, only one data source can be defined at any given time.

Field to apply the metric to, for Average, Sum, or Count Distinct aggregations. You may further be able to aggregate on fields from extended tables.The data is shown in a format that matches the field type. For example, if you select an integer field, such as the Priority field, the data is expressed as a number. If you select a duration field, such as Business duration on the Incident table, the aggregated data is expressed in days, hours, and minutes.

If function fields were created in Report Designer for the table, they are available in the dropdown list. For more information, see Report on function fields.

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. Only one Group by can be defined in the Pareto chart. The Alternative Group By can be defined for a Pareto visualization. For vertical bar, horizontal bar, and pivot reports with multiple data sources: If you group the first source by a choice field, you can group the second source by any applicable choice field.

• 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.

Select the maximum number of groups to display. Groups in excess of this number, determined by sorting, are aggregated into the Others group. You can show that aggregate with the Show others option.By default, you cannot show more than 50 groups. If you have the admin role, you can change this limit in the par_viz.table_data.max_groups system property.

Data for the Max number of groups is evaluated across all periods in the time series to ensure consistent group membership across all dates in the visualization.

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