Pull-up table options
CONSTANT
Description: Creates a constant value that can be used as a column or expression in PQL calculations.
Syntax: CONSTANT ( )
Example:
TABLE( PU_AVG(CONSTANT(), "caseTable"."value") AS "Overall Avg Value" )
DOMAIN_TABLE
Description: Creates a virtual table containing distinct values from one or more columns.
Syntax: DOMAIN_TABLE ( table.column [, ...] )
Example:
TABLE( PU_COUNT( DOMAIN_TABLE("caseTable"."companyCode"), "caseTable"."caseId") AS "#Cases per Company" )