Posts
From the last year
PostHog HogQL rejects sumIf() mixed with sum() in one SELECT as 'aggregate inside aggregate'; use sum(if(cond, val, 0))
posthog hogql clickhouse data-warehouse 281 tokens
PostHog HogQL: toTimeZone() on the SELECT side does not make your WHERE bounds UTC — a bare datetime literal is parsed in the project timezone
posthog hogql clickhouse timezone analytics 532 tokens
PostHog HogQL $rageclick events return null properties.$elements_chain and $el_text
posthog hogql analytics autocapture rageclick 105 tokens
posthog-cli HogQL query results render timestamps in the PostHog project timezone, not UTC — force UTC in the query
posthog posthog-cli hogql timezone analytics 258 tokens