Expand Set Tags

Expand set tags define reusable sets of expansion columns in a definitions block. An expansion block is defined by using an expand-set tag with additional tags between an open { and close } brace.

Tag

Examples

Notes

expand-set

expand-set id = "expand_revenue" {

...

}

Defines the expand-set block. When specified, the id names the block so it can be used elsewhere in the script.

expand

expand "$(summary) MTD" {

text column = "$(summary) MTD" {

value-format "#,###.0"

}

...

}

Starts the block for this expansion definition and provides a label for the column's context menu on a tabular page.

column

text "Sold" column = "Vehicles Sold"

Specifies the data column.

id

expand-set id = "expand_quarters"

Gives the block an identifier that can be referenced in other blocks. Also used to reference the block.

pass-parameter

pass-parameter "summary" "Profit"

Sends the indicated value. Used when invoking the expansion.

NOTE : You can only pass hard-coded strings—expressions are not supported.

take-parameter

expand-set id = "ex-cases-r12" {

take-parameter "summary"

...

}

Accepts the passed value. Used when defining the expansion.

text text "Q1" column = "$(summary) Q1" Specifies the heading.
value-format

text "Var YTD" column = "$(summary) YTD Y-0 Diff"{

value-format "#,###.00"

}

Specifies a display format.

See also What is a Definitions Block?