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