2 // rsrp, rsrq, sinr ranges are 0 .. 127
4 select $window*(tb+1) as TS, $window as measurementInterval,
8 min(rsrp)+0.05*(max(rsrp)-min(rsrp)) as pctl_05_rsrp,
9 min(rsrp)+0.5*(max(rsrp)-min(rsrp)) as median_rsrp,
10 min(rsrp)+0.95*(max(rsrp)-min(rsrp)) as pctl_95_rsrp,
11 sqrt( sum(FLOAT(rsrp)*FLOAT(rsrp)) - sum(FLOAT(rsrp))*sum(FLOAT(rsrp))/count(*)) / count(*) as stddev_rsrp,
12 max(rsrp) as max_rsrp,
13 min(rsrq) as min_rsrq,
14 min(rsrq)+0.05*(max(rsrq)-min(rsrq)) as pctl_05_rsrq,
15 min(rsrq)+0.5*(max(rsrq)-min(rsrq)) as median_rsrq,
16 min(rsrq)+0.95*(max(rsrq)-min(rsrq)) as pctl_95_rsrq,
17 sqrt( sum(FLOAT(rsrq)*FLOAT(rsrq)) - sum(FLOAT(rsrq))*sum(FLOAT(rsrq))/count(*)) / count(*) as stddev_rsrq,
18 max(rsrq) as max_rsrq,
19 min(sinr) as min_sinr,
20 min(sinr)+0.05*(max(sinr)-min(sinr)) as pctl_05_sinr,
21 min(sinr)+0.5*(max(sinr)-min(sinr)) as median_sinr,
22 min(sinr)+0.95*(max(sinr)-min(sinr)) as pctl_95_sinr,
23 sqrt( sum(FLOAT(sinr)*FLOAT(sinr)) - sum(FLOAT(sinr))*sum(FLOAT(sinr))/count(*)) / count(*) as stddev_sinr,
25 from RRCXFER.serv_nr_cell
27 group by systemTime/$window as tb, physCellId