Altair® Panopticon

 

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.