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.