Altair® Panopticon

 

Level

Returns the level in the hierarchy for the node or numbered from the leaf.

Given this data table:

Industry

Supersector

Symbol

3 Month Change %

Financials

Banks

ERST.VI

-0.21

Basic Materials

Basic Resources

VOES.VI

-0.35

Industrials

Construction & Materials

WBSV.VI

-0.50

Health Care

Health Care

ICEL.VI

0.06

Industrials

Industrial Goods & Services

ANDR.VI

0.28

Financials

Insurance

VIGR.VI

-0.10

Oil & Gas

Oil & Gas

OMVV.VI

0.35

Telecommunications

Telecommunications

TELA.VI

0.11

Utilities

Utilities

VERB.VI

-0.12

Financials

Real Estate

ATRV.VI

-0.12

Financials

Banks

BEN.AX

-0.26

Financials

Banks

SUN.AX

-0.28

Financials

Banks

NAB.AX

-0.04

Financials

Banks

ANZ.AX

-0.11

Financials

Banks

CBA.AX

0.03

Basic Materials

Basic Resources

BSL.AX

0.15

Sample 1

Below is the defined breakdown in a Table visualization:

The Levels will be:

Column

Level

Symbol

0

Supersector

1

Industry

2

Root

3

 

This Table visualization is showing the grouping of the columns based on the breakdown hierarchy with 3 Month Change %’s aggregate set to Sum.

 

Changing the aggregate to Level and the format to #,##0.00 will produce this table since the Visible Depth is set until Symbol:

 


 

Sample 2

Clicking on Supersector will make the Symbol breakdown column invisible:

Sample 3

Collapsing columns in the table can also change the Level values:

 

 

 

Sample 4

Clicking to the Root in the breakdown hierarchy:

 

The Level aggregate can also be used when creating calculated columns.

1.     On the Data Table Editor layout page, click Calculated Columns and select Calculated.

 

The Numeric Calculated Column pane displays.

2.     Build the expression with the Level aggregate.

 

For example: 12.0 + [3 Month Change %:level]

When all of the levels are visible in the breakdown (Sample 1), the results will be:

Industry

Supersector

Symbol

3 Month Change %

LevelCalc

Basic Materials

Basic Resources

BSL.AX

0

12.0

 

 

VOES.VI

0

12.0

Financials

Banks

ANZ.AX

0

12.0

 

 

BEN.AX

0

12.0

 

 

CBA.AX

0

12.0

 

 

ERST.VI

0

12.0

 

 

NAB.AX

0

12.0

 

 

SUN.AX

0

12.0

 

Insurance

VIGR.VI

0

12.0

 

Real Estate

ATRV.VI

0

12.0

Health Care

Health Care

ICEL.VI

0

12.0

Industrials

Construction & Materials

WBSV.VI

0

12.0

 

Industrial Goods & Services

ANDR.VI

0

12.0

Oil & Gas

Oil & Gas

OMVV.VI

0

12.0

Telecommunications

Telecommunications

TELA.VI

0

12.0

Utilities

Utilities

VERB.VI

0

12.0

 

Collapsing columns in the table (similar with Sample 3 above) will result to: