JS error messages for which count is greater than 100 in last 30 mins

I need JS error messages for which count is greater than 100 in last 30 mins.
Please help how I can modify the below query to get JS error messages for which count is greater than 100 in last 30 mins

SELECT count(*) FROM JavaScriptError SINCE 30 MINUTES AGO WHERE appName = ‘abc’ FACET errorMessage

Hi @prsharma - You can use a sub-query for this:

SELECT total, errorMessage FROM (SELECT count(*) as 'total' FROM JavaScriptError FACET errorMessage LIMIT MAX) where total > 100 SINCE 30 MINUTES AGO LIMIT MAX