You can assign an aggregate function to columns that contain numeric and non-numeric values in your report. Aggregate functions return a single value, (for example, Average, Maximum, Minimum) calculated from the values in a column. For example, the sum of a column results from adding all the values in the column.
| 1. | Click the down arrow next to a report column that contains numeric values. |
| 2. | Select Aggregation from the menu, then select your aggregation type. |
|
Function Name |
Description |
|
None |
No aggregate function assigned |
|
Average |
Calculates the average value in a given column |
|
Count |
Counts the items in a column Note • Count does not require a numeric value |
|
Count Distinct |
Counts the distinct occurrences of a certain value in a column Note • Count Distinct does not require a numeric value |
|
Max |
Identifies the highest or largest value in a column |
|
Min |
Identifies the lowest or smallest value in a column |
|
Sum |
Calculates a running total sum of the specified column |
The values in the column update.
| 3. | Save the report. |
For information regarding how to correctly get grand total numbers for ENT counts, please see the Knowledge Base article here:
https://bdna.service-now.com/support/kb_view.do?sysparm_article=KB0011604.
BDNA Data Platform 5.5 User Console Help Library02 August 2016 |
Copyright Information | Flexera |