index=KK (A=1 B!="x" C!="y" D=1) OR info OR (E=*) OR F=* OR G=*
| timechart avg(xxx) as RT, sum(eval(if(r1=1,1,0))) as CL, sum(eval(if(isnotnull('B') OR 'AX'!="0", 1, 0))) as ERR, sum(qq) as M, sum(g) as GT, avg(eval(100*cur/max)) as T, sum(CT) as cc, avg(dp) as DD
| fields _time, CL, RT, ERR, M, GT, T, CC, D
| appendcols [ search index=KK W=*
| bucket _time span=5m
| eval ff= mvzip('WA','WB')
| eval fff= mvzip(ff, 'WC')
| mvexpand fff
| rex field=fff "(?<CB>\d+),(?<CM>\d+),(?<P>.+)"
| stats sum(CB) AS cbs , sum(CM) AS cmx by _time
| eval rate=100*(cbs/cmx)
| timechart cont=false max(rate) AS Pool% partial=false ]
... View more