LAYOUT

Layout functions can be used to set the layout, set a theme, enable/disable rails, or expand the hierarchy to a particular level. Let's take a look at the various options.

1. LAYOUT.HIERARCHICAL

Sets the layout option to hierarchy and displays the data in a hierarchical format.

Syntax

LAYOUT.HIERARCHICAL

2. LAYOUT.OUTLINE

Sets the layout option to outline.

Syntax

LAYOUT.OUTLINE

3. LAYOUT.TABLE

Sets the layout option to table.

Syntax

LAYOUT.TABLE

4. LAYOUT.STEPPED

Sets the layout option to stepped.

Syntax

LAYOUT.STEPPED

5. LAYOUT.DRILLDOWN

Sets the layout option to drilldown.

Syntax

LAYOUT.DRILLDOWN

6. LAYOUT.LIGHTTHEME

Sets a light background for the canvas.

Syntax

LAYOUT.LIGHTTHEME

7. LAYOUT.DARKTHEME

Sets a light background for the canvas.

Syntax

LAYOUT.DARKTHEME

8. LAYOUT.AUTOFIT

Fits the maximum possible data in the available space.

Syntax

LAYOUT.AUTOFIT

9. LAYOUT.SETRULER

Fits the maximum possible data in the available space.

Syntax

LAYOUT.SETRULER(TRUE) #Enables the ruler
LAYOUT.SETRULER(FALSE) #Disables the ruler
LAYOUT.SETRULER(THIS) #Control the 'THIS' parameter using a toggle variable button

10. LAYOUT.GOTOCOLUMNLEVEL

Expands the column hierarchy to the specified level. The highest level of the hierarchy is denoted by '0'.

Syntax

LAYOUT.GOTOCOLUMNLEVEL(1) #Expands to the second level of the column hierarchy
LAYOUT.GOTOCOLUMNLEVEL(THIS) #Expands to the specified level which can be set using a numerical stepper variable

11. LAYOUT.GOTOROWLEVEL

Expands the row hierarchy to the specified level. The highest level of the hierarchy is denoted by '0'.

Syntax

LAYOUT.GOTOROWLEVEL(2) #Expands to the third level of the column hierarchy
LAYOUT.GOTOROWLEVEL(THIS) #Expands to the specified level which can be set using a numerical stepper variable