I've got problem understanding this middle thing because it will only work if there are 3 or 5 results. Let's start the easier way. If you have 5 results, you can do a streamstats count as counting by sessionID. After this, you can do something like a sorting - counting sessionID and write down the max counting by sessionID in each line. Then you calculate marker=(maxcounting+1)/2 and search where marker=counting. That means, if you have 5 results, for a sessionID it will look like this: ID=1234, value=a, counting=1, maxcount=5, marker=3 ID=1234, value=b, counting=2, maxcount=5, marker=3 ID=1234, value=c, counting=3, maxcount=5, marker=3 ID=1234, value=d, counting=4, maxcount=5, marker=3 ID=1234, value=e, counting=5, maxcount=5, marker=3 But what will you do if there are 6 events, what's the middle?
... View more