I've done a lot of research on users and I can tell which are more compatible. How do I summarize this at the company level. For example, I'd like to count how many PowerBI * Revit employee nerds I've identified at the company level
Use the Lookup Multiple Rows integration to count prospects with specific criteria at the company level. You can scan columns for company domains/names and count matching values, then use conditional formulas to filter for your specific criteria like "PowerBI ** Revit" skills. Alternatively, use *Get Employee Count by Criteria with People Data Labs - input the company domain and set role filters to count employees matching your technical skill requirements.
Hello Samuel! Thanks for reaching out! Could you share your table link URL and a little more context on what you mean? Would like to know more to be able to assist you in the best possible way!
Hello Samuel! Thanks for reaching out! Could you share your table link URL and a little more context on what you mean? Would like to know more to be able to assist you in the best possible way!
In my People table, I've been scoring people to see if they are good fit or not. So for example, everyone has a score of 0-100. In the company table, I'd like to count how many people in the employee list have a score of 50% or more.
-
Hey Samuel! Can you send me the table link URL instead of the template?

This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.
