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