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, experimentation, surveys, LLM analytics, data warehouse, a CDP, and an AI product assistant to help debug your code, ship features faster, and keep all your usage and customer data in one stack.