Clay doesn’t currently support a true group by or aggregation function like you’d see in SQL you can dedupe and filter records or use formulas to flag things but for real grouping or rollups most people export the data to sheets airtable or a database and do it there. clay is mainly built for row level enrichment rather than analytics.
