Use BQL to create sophisticated scripts that manipulate data directly in Designer reports.
In addition to the basic BQL functionality, the following functions allow sophisticated data manipulation at the report level:
- Expression-level variables - LET
- Custom functions - FUNCTION
- Report-level transformations - TRANSFORM
BQL Overview
BQL Functions
Defining Expressions in Designer
Expressions Reference
Pre-Aggregation
vs. Post-Aggregation Calculations