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