|
TextUnique and TextConcatDistinct
The TextUnique aggregates text fields to distinct values while TextConcatDistinct aggregates text fields to display all possible text values in a comma delimited list.
Given this data table:
|
Country |
Industry |
Company |
1 Day Change % (USD) |
Mcap(USD) |
| AT | Financials | Erste Group Bank AG |
-0.07 |
3439883100 |
| AT | Financials | Raiffeisen International Bank-Holding AG |
-0.07 |
1371987780 |
| AT | Basic Materials | voestalpine AG |
-0.03 |
1412883878 |
| AT | Industrials | Wienerberger AG |
-0.04 |
660942066 |
| AU | Basic Materials | BHP Billiton Ltd. |
-0.06 |
74380605994 |
| AU | Basic Materials | Lihir Gold Ltd. |
0.02 |
5377974426 |
| AU | Basic Materials | Fortescue Metals Group Ltd. |
-0.02 |
2104618718 |
| BE | Financials | KBC Group N.V. |
-0.05 |
2369136539 |
| BE | Basic Materials | Solvay S.A. |
0.04 |
4151907147 |
| BE | Basic Materials | Umicore S.A. |
-0.03 |
2078266946 |
| CA | Consumer Goods | Magna International Inc. Cl A |
-0.05 |
2981991456 |
| CA | Financials | Canadian Imperial Bank of Commerce |
-0.03 |
13960011146 |
The Country, Industry, and Company are text columns while 1 Day Change % (USD) and Mcap(USD) are numeric columns.
Sample 1
Below is the defined breakdown in a Table visualization:
This Table visualization is showing the grouping of the columns based on the breakdown hierarchy with Company, 1 Day Change % (USD), and Mcap(USD) as Visual Members and with the corresponding aggregates:
|
Column |
Aggregate |
|
Company |
TextUnique |
|
1 Day Change % (USD) |
Sum |
|
Mcap(USD) |
Sum |
By default, the aggregate of Company is set to TextUnique.
The Table visualization now displays the distinct text values of a Company for the breakdown columns, Country and Industry.
|
Company |
1 Day Change % (USD) |
Mcap(USD) |
||
| AT
|
Basic Materials | voestalpine
AG
|
-0.03 |
1412883878 |
| Financials |
-0.14 |
4811879880 |
||
| Industrials | Wienerberger AG |
-0.04 |
660942066 |
|
| AU | Basic Materials |
-0.06 |
81863199138 |
|
| BE | Basic Materials |
-0.02 |
6230174093 |
|
| Financials |
-0.05 |
2369136539 |
||
| CA | Consumer Goods | Magna International Inc. Cl A |
-0.05 |
2981991456 |
| Financials | Canadian Imperial Bank of Commerce |
-0.03 |
13960011146 |
|
If the aggregate for the Company column is changed to TextConcatDistinct, all of the text values for the corresponding breakdown columns are displayed in a comma delimited list:
|
Company |
1 Day Change % (USD) |
Mcap(USD) |
||
| AT
|
Basic
Materials
|
voestalpine AG |
-0.03 |
1412883878 |
| Financials
|
Erste Group Bank AG, Raiffeisen International Bank-Holding AG |
-0.14 |
4811879880 |
|
| Industrials | Wienerberger AG |
-0.04 |
660942066 |
|
| AU | Basic Materials |
BHP Billiton Ltd., Lihir Gold Ltd., Fortescue Metals Group Ltd. |
-0.06 |
81863199138 |
| BE | Basic Materials | Solvay S.A., Umicore S.A. |
-0.02 |
6230174093 |
| Financials | KBC Group N.V. |
-0.05 |
2369136539 |
|
| CA | Consumer Goods | Magna International Inc. Cl A |
-0.05 |
2981991456 |
| Financials | Canadian Imperial Bank of Commerce |
-0.03 |
13960011146 |
|
You can opt to display a text column as a distinct count. Refer to CountDistinct for more information.