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