Supported aggregations
Contents
This is an ever-expanding list of enabled aggregations.
You can find their full definitions in the ClickHouse documentation. Additionally, we include a list of popular ones and their uses in the HogQL expressions and SQL insight documentation.
Standard aggregate functions
countcountIfcountStatecountMergecountStateIfcountDistinctIfcountMapIfminminForEachminIfmaxmaxIfsumsumForEachsumIfavgavgIfavgMapavgMapIfavgMapStateavgMapMergeavgMapMergeIfanyanyIfstddevPopstddevPopIfstddevSampstddevSampIfvarPopvarPopIfvarSampvarSampIfcovarPopcovarPopIfcovarSampcovarSampIfcorr
ClickHouse-specific aggregate functions
anyHeavyanyHeavyIfanyLastanyLastIfargMinargMinIfargMinMergeargMaxargMaxIfargMaxMergeavgStateavgStateIfavgMergeavgMergeIfavgWeightedavgWeightedIfavgArraytopKgroupArraygroupArrayIfgroupUniqArraygroupUniqArrayIfgroupArrayInsertAtgroupArrayInsertAtIfgroupArrayMovingAvggroupArrayMovingAvgIfgroupArrayMovingSumgroupArrayMovingSumIfgroupArraySamplegroupArraySampleIfgroupBitAndgroupBitAndIfgroupBitOrgroupBitOrIfgroupBitXorgroupBitXorIfgroupBitmapgroupBitmapIfgroupBitmapAndgroupBitmapAndIfgroupBitmapOrgroupBitmapOrIfgroupBitmapXorgroupBitmapXorIfsumWithOverflowsumWithOverflowIfdeltaSumdeltaSumIfdeltaSumTimestampdeltaSumTimestampIfsumMapsumMapIfsumMapMergesumMapMergeIfsumMergesumMergeIfsumStatesumStateIfminMapminMapIfmaxMapmaxMapIfmedianmedianIfmedianExactmedianExactIfmedianExactLowmedianExactLowIfmedianExactHighmedianExactHighIfmedianExactWeightedmedianExactWeightedIfmedianTimingmedianTimingIfmedianTimingWeightedmedianTimingWeightedIfmedianDeterministicmedianDeterministicIfmedianTDigestmedianTDigestIfmedianTDigestWeightedmedianTDigestWeightedIfmedianBFloat16medianBFloat16IfmedianArrayskewSampskewSampIfskewPopskewPopIfkurtSampkurtSampIfkurtPopkurtPopIfuniquniqIfuniqExactuniqExactIfuniqHLL12uniqHLL12IfuniqThetauniqThetaIfuniqMergeuniqMergeIfuniqMapuniqMapMergeuniqMapMergeIfuniqStateuniqStateIfuniqUpToMergeuniqExactMergequantilequantileIfquantilesquantilesIfsimpleLinearRegressionsimpleLinearRegressionIfcontingencycontingencyIfcramersVcramersVIfcramersVBiasCorrectedcramersVBiasCorrectedIftheilsUtheilsUIfmaxIntersectionsmaxIntersectionsIfmaxIntersectionsPositionmaxIntersectionsPositionIfwindowFunnelmd5
PostgreSQL-style aggregate functions
array_aggjson_aggstring_aggevery
PostHog is an all-in-one developer platform for building successful products. We provide product analytics, web analytics, session replay, error tracking,feature flags, experiments, surveys, LLM analytics, data warehouse, CDP, and anAI product assistant to help debug your code, ship features faster, and keep all your usage and customer data in one stack.