Skip to content

Instantly share code, notes, and snippets.

@ritec

ritec/user_agent.sql

Created January 11, 2018 22:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ritec/4f17519fb319d5e0d25ddc2e2c9583ca to your computer and use it in GitHub Desktop.
Save ritec/4f17519fb319d5e0d25ddc2e2c9583ca to your computer and use it in GitHub Desktop.
Download ZIP
New Relic Percentage User Agent
Raw
user_agent.sql
select percentage(uniquecount(session), where userAgentName = 'Chrome') as 'Chrome', percentage(uniquecount(session), where userAgentName = 'Firefox') as 'FireFox', percentage(uniquecount(session), WHERE userAgentName='IE') as 'IE' , percentage(uniquecount(session), WHERE userAgentName ='Safari') as 'Safari' from PageView SINCE 600 minutes ago
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment