| o.ar.s.sum=sum(int_id) |
| o.ar.s.unique=unique(long_ld) |
| o.ar.s.su=add(sum(int_id),unique(long_ld)) |
| o.ar.s.mean=mean(int_id) |
| o.ar.s.count=count(long_ld) |
| o.ar.s.median=median(int_id) |
| o.ar.s.mcm=add(mean(int_id),count(long_ld),median(int_id)) |
| |
| o.mr.s.sum=sum(int_id) |
| o.mr.s.unique=unique(long_ld) |
| o.mr.s.su=mult(sum(int_id),unique(long_ld)) |
| o.mr.s.mean=mean(int_id) |
| o.mr.s.count=count(long_ld) |
| o.mr.s.median=median(int_id) |
| o.mr.s.mcm=mult(mean(int_id),count(long_ld),median(int_id)) |
| |
| o.dr.s.sum=sum(int_id) |
| o.dr.s.unique=unique(long_ld) |
| o.dr.s.su=div(sum(int_id),unique(long_ld)) |
| o.dr.s.mean=mean(int_id) |
| o.dr.s.count=count(long_ld) |
| o.dr.s.mc=div(mean(int_id),count(long_ld)) |
| |
| o.pr.s.sum=sum(int_id) |
| o.pr.s.unique=unique(long_ld) |
| o.pr.s.su=pow(sum(int_id),unique(long_ld)) |
| o.pr.s.mean=mean(int_id) |
| o.pr.s.count=count(long_ld) |
| o.pr.s.mc=pow(mean(int_id),count(long_ld)) |
| |
| o.nr.s.sum=sum(int_id) |
| o.nr.s.s=neg(sum(int_id)) |
| o.nr.s.count=count(long_ld) |
| o.nr.s.c=neg(count(long_ld)) |
| |
| o.avr.s.sum=sum(int_id) |
| o.avr.s.s=abs(neg(sum(int_id))) |
| o.avr.s.count=count(long_ld) |
| o.avr.s.c=abs(neg(count(long_ld))) |
| |
| o.cnr.s.c8=8 |
| o.cnr.s.c10=10.0 |
| |
| o.dmr.s.median=median(date_dtd) |
| o.dmr.s.cme="+2YEARS" |
| o.dmr.s.dmme=date_math(median(date_dtd),"+2YEARS") |
| o.dmr.s.max=max(date_dtd) |
| o.dmr.s.cma="+2MONTHS" |
| o.dmr.s.dmma=date_math(max(date_dtd),"+2MONTHS") |
| |
| o.cdr.s.cd1=1800-12-31T23:59:59Z |
| o.cdr.s.cs1="1800-12-31T23:59:59Z" |
| o.cdr.s.cd2=1804-06-30T23:59:59Z |
| o.cdr.s.cs2="1804-06-30T23:59:59Z" |
| |
| o.csr.s.cs1="this is the first" |
| o.csr.s.cs2="this is the second" |
| o.csr.s.cs3="this is the third" |
| |
| o.cr.s.csmin="this is the first" |
| o.cr.s.min=min(string_sd) |
| o.cr.s.ccmin=concat("this is the first",min(string_sd)) |
| o.cr.s.csmax="this is the second" |
| o.cr.s.max=max(string_sd) |
| o.cr.s.ccmax=concat("this is the second",max(string_sd)) |