I need to know the pages, along with the count of how many times their response time exceeded 100. I need the top 10 such pages ordered by their count. I wrote the following search query, but did not get success. Please help.
...| eval timesec = round(timetaken/1000) | where timesec > 100 | stats count as cnt by csuri_stem | sort cnt 10 -