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.
| NAME | DESCRIPTION |
|---|---|
| LAYOUT.HIERARCHY | Sets the layout to hierarchy |
| LAYOUT.OUTLINE | Sets the layout to outline |
| LAYOUT.TABLE | Sets the layout to table |
| LAYOUT.STEPPED | Sets the layout to stepped |
| LAYOUT.DRILLDOWN | Sets the layout to drilldown |
| LAYOUT.LIGHTTHEME | Applies a light canvas |
| LAYOUT.DARKTHEME | Applies a dark canvas |
| LAYOUT.AUTOFIT | Fits the maximum possible data in the available space |
| LAYOUT.SETRULER | Enable or disable the ruler |
| LAYOUT.GOTOCOLUMNLEVEL | Expands the column hierarchy to the specified level |
| LAYOUT.GOTOROWLEVEL | Expands the row hierarchy to the specified level |
Sets the layout option to hierarchy and displays the data in a hierarchical format.
LAYOUT.HIERARCHICAL.png)
Layout hierarchical
Sets the layout option to outline.
LAYOUT.OUTLINE.png)
Setting the layout to outline
Sets the layout option to table.
LAYOUT.TABLE.png)
Setting the layout to table
Sets the layout option to stepped.
LAYOUT.STEPPED.png)
Setting the layout to stepped
Sets the layout option to drilldown.
LAYOUT.DRILLDOWN.png)
Setting the layout to drilldown
Sets a light background for the canvas.
LAYOUT.LIGHTTHEME.png)
Setting a light canvas
Sets a light background for the canvas.
LAYOUT.DARKTHEME.png)
Setting a dark background
Fits the maximum possible data in the available space.
LAYOUT.AUTOFIT.png)
Autofit layout
Fits the maximum possible data in the available space.
LAYOUT.SETRULER(TRUE) #Enables the ruler
LAYOUT.SETRULER(FALSE) #Disables the ruler
LAYOUT.SETRULER(THIS) #Control the 'THIS' parameter using a toggle variable button.png)
Ruler enabled using set ruler
Expands the column hierarchy to the specified level. The highest level of the hierarchy is denoted by '0'.
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.png)
Expanding the column hierarchy
Expands the row hierarchy to the specified level. The highest level of the hierarchy is denoted by '0'.
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.png)
Expanded row hierarchy
