Pricing
Get started – free
  • Home
  • Self-driving product
  • Context warehouse
  • Pricing
  • Docs
  • Demo
  • Talk to a human
  • About us
  • Changelog
  • Company handbook
  • Store
  • Careers
  • Trash
  • Home
  • Self-driving product
  • Context warehouse
  • Pricing
  • Docs
  • Demo
  • Talk to a human
  • About us
  • Changelog
  • Company handbook
  • Store
  • Careers
  • Trash
Tools and features
Toolbar
Heatmaps
Notebooks
Activity
VS Code extension
Health checks
Organizations
Projects
Hog
SQL access
Overview
SQL expressions
Supported functions
Supported aggregations
Optimizing SQL queries
Tutorials
Access control
Activity logs
Approvals
SSO, SAML, & SCIM
ID-JAG (XAA)
Agent discovery (auth.md)
Content Security Policy tracking
Command palette
Account settings
JS snippets

SQL tutorials

Contents

Got a question which isn't answered below? Head to the community forum to let us know!

Check our product analytics tutorials for more information about analyzing events.

Examples

  • How to do time-based breakdowns (hour, minute, real time) in HogQL
  • The power of SQL's sum() aggregation
  • Using SQL for advanced time and date filters
  • Using SQL for advanced breakdowns
  • How to filter and breakdown arrays with SQL
  • How to use Recharts to visualize analytics data
  • How to use React Charts to visualize analytics data (with examples)

Analyzing events

  • How to analyze autocapture events with SQL
  • How to analyze first and last touch attribution
  • How to calculate time on page with SQL
  • How to calculate bounce rates with SQL

Was this page useful?

Jump to: