Tutorials - Hogql - PostHog

Products
Pricing
Docs

Community
Company
Login

Docs

Overview

- Start here
- Install PostHog
- Send events
- Identify users
- User properties
- Actions & insights
- Group analytics
- Next steps

- JavaScript Popular
- Android Popular
- Elixir
- Flutter
- Go
- iOS Popular
- Java
- Node.js
- PHP
- Python
- React Popular
- React Native Popular
- Ruby
- Rust

- Overview
- Docusaurus v2 3rd party
- Gatsby 3rd party
- Google Tag Manager
- Next.js
- Nuxt.js
- Retool
- RudderStack
- Segment
- Sentry
- Slack
- Shopify
- Vue.js
- WordPress

- Overview
- POST-only public endpoints
- Actions
- Annotations
- Cohorts
- Dashboards
- Event definitions
- Events
- Experiments
- Feature flags
- Funnels
- Group analytics
- Groups types
- Insights
- Invites
- Members
- Persons
- Plugin configs
- Plugins
- Projects
- Property definitions
- Session recordings
- Trends
- Users
- Data model

- Overview
- Microsoft Teams
- Slack
- Discord

- Using a CDP
- Deploying a reverse proxy
  - Caddy
  - Cloudflare
  - AWS CloudFront
  - Next.js
  - Netlify
  - Vercel
- Browser extensions

Products

Product analytics
- Overview
- Correlation analysis
- Dashboards
- Funnels
- Group analytics
- HogQL Beta
- Insights
- Lifecycle
- Retention
- Sampling Beta
- Stickiness
- Subscriptions
- Toolbar
- Trends
- User paths

Session replay
- Overview
- Product manual
- Privacy Controls
- Sharing and emedding
- Data retention
- Iframe recording
- Troubleshooting and FAQs

Feature flags
- Overview
- Product manual
- Bootstrapping & local evaluation
- Rollout strategies
- Multivariate feature flags
- Payloads
- Early Access Feature Management
- Common questions about feature flags

A/B testing
- Overview
- Product manual
- Statistical significance
- Under the hood
- Common questions about experiments

Surveys
- Manual Beta

Data
- Overview
- Actions
- Annotations
- Autocapture
- Cohorts
- Data management
- Events
- Identify
- Organizations & projects
- Persons
- Role-based access
- Sessions
- Settings
- SSO & SAML
- Team collaboration
- User properties
- UTM segmentation

Data connections
- - Amazon Kinesis Import
  - BitBucket Release Tracker
  - Event Replicator
  - GitHub Release Tracker
  - GitHub Star Sync
  - GitLab Release Tracker
  - Heartbeat
  - Ingestion Alert
  - Email Scoring
  - n8n Connector
  - Orbit Connector
  - Redshift Import
  - Rudderstack Import
  - Segment Connector
  - Shopify Connector
  - Stripe Connector
  - Twitter Followers Tracker
  - Zendesk Connector
- - Airbyte Exporter
  - Amazon S3 Export
  - Avo Inspector
  - BigQuery Export
  - Customer.io Connector
  - Databricks Export
  - Engage Connector
  - GCP Pub/Sub Connector
  - Google Cloud Storage Export
  - Hubspot Connector
  - Intercom Connector
  - PagerDuty Connector
  - PostgreSQL Export
  - Redshift Export
  - RudderStack Export
  - Salesforce Connector
  - Sendgrid Connector
  - Sentry Connector
  - Snowflake Export
  - Twilio Connector
  - Variance Connector
  - Pace Integration
  - Zapier Connector
- - Downsampler
  - Event Sequence Timer
  - Filter Out
  - First Time Event Tracker
  - Property Filter
  - Property Flattener
  - Schema Enforcer
  - Taxonomy Standardizer
  - Unduplicator
- - Advanced GeoIP Enricher
  - Automatic Cohort Creator
  - Currency Normalizer
  - GeoIP Enricher
  - Timestamp Parser
  - URL Normalizer
  - User Agent Populator
- - Overview
  - Tutorial
  - Troubleshooting
  - Developer reference
  - Using the PostHog API
  - Jobs
  - Testing
  - TypeScript types

Apps
- Feedback Widget
- Notification Bar
- NPS Survey
- Pineapple Mode
- User Interviewer

Host & migrate

- Overview
- - Overview
  - Upgrade notes
- - Instance settings
  - Environment variables
  - Securing PostHog
  - Monitoring with Grafana
  - Running behind a proxy
  - Configuring email
  - Helm chart configuration
  - Deploying ClickHouse using Altinity.Cloud
  - Configuring Slack
- - Overview
  - Overview
    0001-events-sample-by
    0002_events_sample_by
    0003_fill_person_distinct_id2
  - ClickHouse
    Backup
    Debug hanging / freezing process
    Horizontal scaling (Sharding & replication)
    Kafka Engine
    Resize disk
    Restore
    Vertical scaling
    Debugging load
    Kafka
    Resize disk
    Log retention
    PostgreSQL
    Resize disk
    Troubleshooting long-running migrations
    Plugin server
    Overview
    Jobs not executing
    Scheduled tasks not executing
    MinIO
    Redis
    Zookeeper
  - Disaster recovery
- Troubleshooting and FAQs
- Support
- Disclaimer

- Ingest historical data
- Migrate to PostHog Cloud
- Migrate between PostHog instances
- Migrate from Amplitude
- Migrate to PostHog Cloud EU
- Migrate from a broken self-hosted instance
- Export your events

Resources

- Overview
- Data model
- Ingestion pipeline
- ClickHouse
- Querying data

- Overview
- GDPR guidance
- HIPAA guidance
- CCPA guidance
- SOC 2
- Data egress & compliance
- Data deletion

- All
- Actions
- Apps
- Cohorts
- Configuration
- Data management
- Dashboards
- Experimentation
- Feature flags
- Funnels
- Group analytics
- Heatmaps
- Insights
- Path analysis
- Retention
- Session replay
- Toolbar
- Trends

- Overview
- Code of conduct
- Recognizing contributions
- Badge

Support options

Library comparison

Glossary

Tutorials
Hogql

Hogql

LatestPopular

How to analyze autocapture events with HogQL
Jun 7, 2023
- Ian Vanagas
The power of HogQL’s sum() aggregation
Jun 6, 2023
- Ian Vanagas
Using HogQL for advanced time and date filters
May 30, 2023
- Ian Vanagas
Using HogQL for advanced breakdowns
May 16, 2023
- Ian Vanagas

The best of PostHog.
Delivered twice a month.

Products
Product analytics
Session replay
Feature flags
A/B testing
Product OS
Data connections
Apps
Customer stories
PostHog vs...
Pricing

Docs
Start here
Install PostHog
Send events
Integrations
Build an app
API
Webhooks

Using PostHog
Product analytics
Session recording
Feature flags
A/B testing
Data
Apps
Tutorials
Tracks

Community
Questions?
Product roadmap
Contributors
Newsletter
Merch
PostHog FM
PostHog on GitHub
Startups

Handbook
Getting started
Company
Strategy
How we work
Small teams
People & Ops
Engineering
Product
Design
Marketing
Customer success

Company
About
Team
Investors
Press
Blog
FAQ
Support
Careers

© 2023 PostHog, Inc.

System status
SOC 2
Privacy policy
Terms