Trend reports

Group report data using the values of this field. For example, in an incident report grouped by Assignment group, all incidents that belong to Software, Service Desk, and Network are placed in separate groups. To group by fields on extended tables, see How to report on extended tables. Select the info icon

Note:

• It is not possible to group or stack reports by the Tags field, or by certain MySQL database field types, such as MEDIUMTEXT. For more information, see Database field type.
• Grouping or stacking by Variables or Questions fields is not supported for reports based on database views.

Extra fields to group the report by. When you select Additional group by fields or function fields, the report includes a control at the bottom that allows you to group the report by any one of the additional fields. To group by fields on extended tables as well, see How to report on extended tables. Select the info icon

Note:

• You can see choices in the Additional group by list that do not appear in the main Group by list. The report does not support grouping or stacking by the extra fields you see. Unlike the main Group by choices, the Additional group by fields are not filtered. If you select an unsupported field, it has no effect.
• The limitations listed for the main Group by field also apply to the Additional group by field. For more information, see Add an additional group by or stack by.

Mathematical calculation to perform on the data. The default is Count, which shows the number of records selected.To show only unique records, select Count Distinct.

Select Average, Sum, or Count Distinct, to show a list of fields from the selected Table. Select a field to Aggregate by from this list.

If you group the report by a field and select an Average aggregate, you get the average of each group. If a Total value is shown, it is the average of these group averages, not of the individual field values.

Select Minimum or Maximum to show the maximum or minimum value for each segment of the report.

For more information on aggregation options, see Aggregation in reporting.

If you choose Average,Sum, Count Distinct, Minimum, or Maximum, you may be able to aggregate on fields from extended tables. See How to report on extended tables.

For information about aggregating on FX currency values, see FX Currency values in reporting.

Method of calculating percentages. The percentage appears when you point to a report segment, such as a bar on a bar report. This field appears when Aggregation is set to Average, Sum, or Count Distinct.

• Use Aggregation calculates the percentage using the selection in the Aggregation field. Only data that is displayed in the report is used to calculate the percentage.

For example, a report shows assets by department with the Aggregation set to Sum and the percentage calculated using aggregation. If the total cost of assets is $100,000 and the cost of assets for Customer Support is $10,000, the percentage for Customer Support is 10%.

• Use Record Count calculates the percentage using the total number of records in the data set.

For example, a report shows incidents by priority. Out of 500 incident records, 200 have low priority. The percentage for the low-priority section is 40%.

Enables you to configure how to show numerical values in reports, including decimal precision, rounding, minimum and maximum duration units, and abbreviations for duration units. See Value formatting in reports.

Note: Decimal precision does not work on currency fields.

Maximum number of groups that the Trend by condition returns. This limit only affects the x-axis. The number of groups that the Group by condition returns on the y-axis is not affected.

The groups with highest values are shown first. Any groups beyond the limit are combined into the single group Other.

If you select Show all, the 50 largest Trend by groups are displayed on the x-axis. If there are more than 50 groups, the remainder are grouped as Other.

Source of colors used in the report.If you do not group or stack the report, Use one color is automatically selected. In this case, select a single, predefined system color.

If you group or stack the report, select one of the following options:

• Use color palette: Select a color palette from the predefined system color palettes.
• Use several colors: Define a custom set of Colors using hex codes. You can add any number of colors.
• Use chart colors: Use the colors defined in Reports > Chart Colors.

For more information about the differences between these options, see Predefined colors in reports.

Number of decimal places to show. You can show from zero to four decimal places. Default value: 2. To change the default value, create the system property glide.chart.decimal.precision and specify the value. Note: Percentage labels do not change accordingly with the decimal precision specified.

Specify a minimum Y-axis value to limit the amount of information in the report. If you select an aggregation field that is not of the type Number, the From and To fields are not available.Note:

• Depending on configured Highcharts settings, the minimum value may be rounded up or down. If you require the settings that affect this changed, contact the administrator.
• If you format duration fields additionally using Set Value Formatting from the Configure tab:
• Values entered in the From/To fields (Style > Y axis) are in seconds. The visualization displays y-axis labels as the selected Minimum/Maximum duration unit (Configure > Set Value Formatting), and returns data that falls within the From/To (seconds) values.
• Example: If you set the minimum and maximum duration unit to Minute, the visualization displays y-axis labels as minutes, and returns data which falls within the corresponding seconds values set in the From/To fields.

Specify a maximum Y-axis value to limit the amount of information in the report. If you select an aggregation field that is not of the type Number, the From and To fields are not available.Note:

• Depending on configured Highcharts settings, the minimum value may be rounded up or down. If you require the settings that affect this changed, contact the administrator.
• If you format duration fields additionally using Set Value Formatting from the Configure tab:
• Values entered in the From/To fields (Style > Y axis) are in seconds. The visualization displays y-axis labels as the selected Minimum/Maximum duration unit (Configure > Set Value Formatting), and returns data that falls within the From/To (seconds) values.
• Example: If you set the minimum and maximum duration unit to Minute, the visualization displays y-axis labels as minutes, and returns data which falls within the corresponding seconds values set in the From/To fields.