The Visualizer
Expression Builder helps you add report-level attributes, measures, or filters based on BQL expressions. You can make these available to other reports in the same space using the Make Global option.
After an expression is saved in the Expression Builder, the user and date for the latest
modification show on the bottom left of the page.
Note: Expression Builder includes integrated syntax help,
validation, and pretty-printing. You can access it from the same {} menu.
Note: The Expression Editor Basic mode displays attributes and measures from multiple subject
areas to build your expressions and you can save expressions in either a Custom Subject
Area or the Default Subject Area.
Note: For Visualizer tables you can use BQL expressions to specify
conditional formatting.
BQL provides many functions and operators for expressions in Visualizer. See Supported functions and operators in Visualizer expressions.
The Expression Builder supports a visually-oriented Basic mode and a text-oriented Advanced
mode. In Basic mode, the Expression Builder provides type-ahead search to make it easy to
add columns, operators, and functions. Use Advanced mode when you want to type a new or
copy-paste an existing BQL expression.
Note: Some functions are
supported only in Advanced mode.
Expressions you create are available in the Visualizer Subject Area and you can
use them like any regular measure or attribute.
Caution:
By default report expressions created in
Visualizer are only available for the current report; they are not available for use in
other reports. You can make an expression available across the space by clicking Make
Global. This is also called a "saved expression". The ability to make an expression global
requires the Admin - Manage Access - Manage Groups - Modify Saved Expressions
privilege.
Saved expressions that have been created
in Designer can also be used in Visualizer reports.
Expression filters are display filters and apply
against the query result set in memory.