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 |
| Industrials | 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.
- On the Data Table Editor layout page, click Calculated Columns and select Calculated.
The Numeric Calculated Column pane displays.
- 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:
(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.