Hi guys -
I want to create a list of page view counts grouped by raw user agent string to detect bot traffic. I came up with this statement which returns an empty result. Obviously, my solution is wrong
SELECT count(*) FROM PageView FACET
request.headers.userAgent SINCE 1 day ago
Can you point me into the right direction?