Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

Counting Unique Domains in a Clay Table After Filtering | Clay

Counting Unique Domains in a Clay Table After Filtering

·Aug 11, 2025 11:36 AM·

I want to count the unique domains which are in a column in a Clay table after applying the filter. How do I do that via a formula

1 comment

· Sorted by Oldest

Clay
APP
·
·
Use an AI formula to count unique domains in your filtered table: 1. Add a new "formula" column to your table 2. Choose "Ask question about items with AI" from the column options 3. Prompt the AI to count the unique domains from your domain column The AI will generate the appropriate code to count unique values. You can also use the "Normalize and Deduplicate a List" integration which removes duplicate entries and provides both a deduped list object and string output. The AI might not give you exactly what you need on the first try - iterate on your prompts or modify the generated code using the preview feature .
Sources: AI Formulas + Conditional Runs [Clay 101] - Clay University AI Formulas + Conditional Runs [Automated Outbound] - Clay University AI Formulas + Conditional Runs [Automated Inbound] - Clay University Normalize and Deduplicate a List with Clay