Jump to: navigation, search

Appendix A: Statistical Formula Definition

Parameter Possible Value
formula
  • <aggregate>
aggregate
  • <aggr_boolean> ? <aggregate> : <aggregate>
  • <aggregate> ^ <aggregate>
  • <aggregate> % <aggregate>
  • <aggregate> + <aggregate>
  • <aggregate> - <aggregate>
  • <aggregate> * <aggregate>
  • <aggregate> / <aggregate>
  • - <aggregate>
  • ( <aggregate> )
  • <system_proc1> ( <aggregate> )
  • <system_proc2> ( <aggregate> , <aggregate> )
  • greatest ( <aggregate_list> )
  • least ( <aggregate_list> )
  • <aggregate_func> ( <action_types_list> ; <number> ; <condition> )
  • <aggregate_func> ( <action_types_list> ; <number> )
  • COUNT ( <action_types_list> ; <condition> )
  • COUNT ( <action_types_list> )
  • @COUNT ( <action_types_list> ; <condition> )
  • @COUNT ( <action_types_list> )
  • <float literal> * <int literal> * <sys_var>
aggr_boolean
  • <aggr_boolean> & <aggr_boolean>
  • <aggr_boolean> | <aggr_boolean>
  • ~ <aggr_boolean>
  • ( <aggr_boolean> )
  • <aggregate> = <aggregate>
  • <aggregate> != <aggregate>
  • <aggregate> < <aggregate>
  • <aggregate> <= <aggregate>
  • <aggregate> > <aggregate>
  • <aggregate> >= <aggregate>
aggregate_list
  • <aggregate>
  • <aggregate> , <aggregate_list>
action_operand
  • <action type>
  • ~ <action_type>
  • *
action_types_list
  • <action_operand>
  • <action_types_list> , <action_operand>
condition
  • <boolean>
boolean
  • <boolean> & <boolean>
  • <boolean> | <boolean>
  • ~ <boolean>
  • ( <boolean> )
  • <kv_boolean>
  • <number> = <number>
  • <number> != <number>
  • <number> < <number>
  • <number> <= <number>
  • <number> > <number>
  • <number> >= <number>
  • <string> = <string>
  • <string> != <string>
  • rank_lt ( <number> , <int literal> )
  • rank_gt ( <number> , <int literal> )
number
  • <boolean> ? <number> : <number>
  • greatest ( <number>_list )
  • least ( <number>_list )
  • <number> ^ <number>
  • <number> % <number>
  • <number> + <number>
  • <number> - <number>
  • <number> * <number>
  • <number> / <number>
  • - <number>
  • ( <number> )
  • <system_proc1> ( <number> )
  • <system_proc2> ( <number> , <number> )
  • <num_attr>
  • <kv_number>
  • <float literal>
  • <int literal>
  • convert ( <string> )
  • <sys_var>
number_list
  • <number>
  • <number> , <number_list>
num_attr
  • duration
  • start
  • end
string
  • <string> + <string>
  • <kv_string>
  • sub ( <string> , <int literal> , <int literal> )
  • upper ( <string> )
  • lower ( <string> )
  • <string_literal>
kv_string
  • kvstr ( <kv_attrib> , <string> )
  • kvstr ( <kv_attrib> , <string> , <int> )
kv_number
  • kvnum ( <kv_attrib> , <string> , <int> )
  • kvnum ( <kv_attrib> , <string> )
  • kvsum ( <kv_attrib> , <string> )
  • kvmin ( <kv_attrib> , <string> )
  • kvmax ( <kv_attrib> , <string> )
  • kvavg ( <kv_attrib> , <string> )
kv_boolean
  • kvexists ( <kv_attrib> , <string> , <string> )
kv_attrib
  • <kv_atomic_attrib>
  • kvlist ( <kv_attrib> , <string> )
  • kvlist ( <kv_attrib> , <string> , <int> )
kv_atomic_attrib
  • udata
  • global_udata
  • reasons
  • extensions
  • system
int
  • <int literal>
  • - <int literal>
system_proc1
  • log
  • exp
  • sqrt
  • sin
  • cos
  • abs
  • ceil
  • floor
system_proc2
  • pow
aggregate_func
  • SUM
  • MAX
  • MIN
  • AVG
  • @SUM
  • @MAX
  • @MIN
  • @AVG
sys_var
  • $istart
This page was last edited on January 8, 2018, at 20:21.
Comments or questions about this documentation? Contact us for support!