Unique
The Unique aggregation is used with numeric values and will display a number in case all the values in a group are the same , otherwise it will show empty/null. This aggregation can be used as an indicator of a logical test: “if the numeric values
in this group and in any subgroups are identical, then show the numeric value, or else show nothing”.
Sample 1
| Group1 | Group2 | same_value_all | same_value_in_group | mixed_value |
| root | a | 7 | 3 | 2 |
| root | a | 7 | 3 | 1 |
| root | a | 7 | 3 | 4 |
| root | b | 7 | 6 | 5 |
| root | b | 7 | 6 | 4 |
| root | b | 7 | 6 | 7 |
The Unique for each field with Group1 as breakdown item:
| Group1 | Group2 | same_value_all | same_value_in_group | mixed_value |
| 7 |
The Unique for each field with Group1 and Group2 as breakdown items:
| Group1 | Group2 | same_value_all | same_value_in_group | mixed_value |
| 7 | 3 | |||
| 7 | 6 |
(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.