SETBLANKLABEL

SETBLANKLABEL can be used to replace blank row or column categories with custom text.

Syntax

SETBLANKLABEL.<ROW/COLUMN>(VALUE)

Arguments

VALUE - Pass the custom value to use instead of blank categories.

Example

SETBLANKLABEL.ROW('row_label')
SETBLANKLABEL.COLUMN('col_label')

SETBLANKLABEL function used in a variable

Notice how the blank row and column categories are replaced with the custom text "DESC". The buttons use the SETBLANKLABEL script internally.

SETBLANKLABEL function in action