SQL tutorials

Last updated: Feb 24, 2025

|Edit this page

On this page

Examples
Analyzing events

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

Questions? Ask Max AI.

It's easier than reading through 604 docs articles.

Community questions

Was this page useful?

Organizations

Multiple organizations and projects aren't available on open source hobby deployments. Organizations An organization is the highest abstraction level within a PostHog instance. It's made up of projects (see more on them here ) and members. Most commonly a PostHog organization represents a real-world company or other type of isolated grouping. Use the organization dropdown in the top bar to switch between organizations or create a new one. PostHog Cloud users can create, manage, and join…