| makeresults | eval var="a,a,a,b,a,c,c,b" | makemv delim="," var | mvexpand var |sort var | streamstats count by var |table var count |eval i=0 |eval count1=if(count==1,i,i+1) |streamstats count(eval(count1==0)) as req_col |table var req_col ... View more