Clay Icon

Filtering Unique Values to Display a Set Number in Tables

·
·

Is there a way to do something like "show only 3 of this exact value" For example if we have 5 data points with the same value (e.g. website), is there a way to filter on the whole table how many per unique value should be shown?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, you can filter a table to show a specific number of data points per unique value. Here's how you can do it: 1. Use the Lookup Multiple Rows function to identify duplicate values. 2. Create a formula column that assigns a number to each occurrence of a value. 3. Use table filters to show only the rows with the desired occurrence numbers. For example, to show only 3 instances of each website: 1. Set up the Lookup Multiple Rows for the website column. 2. Create a formula that returns 1, 2, 3, etc. based on the occurrence order. 3. Apply a filter to show only rows where the formula result is 1, 2, or 3. This approach allows you to control how many instances of each unique value are displayed.

  • Avatar of Lazar R.
    Lazar R.
    ·
    ·

    Not really what I was getting at. Lets say if there are also 10 instances of the same value, I would still like the possibility of filtering for 3 only (or any random number, similar to how we can do it with hte job search)

  • Avatar of Lazar R.
    Lazar R.
    ·
    ·

    If this doesn't exist yet, I'd like to suggest it as a feature, for GTM particularly it will be incredibly useful, let's say you want to reach out to only 3 people from the same company, but have more than 3 in the company table, this way you could do mass selections way easier.

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Lazar, Absolutely — Here’s a quick tutorial and a formula that can help: {{Unique ID}}?({{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())> -1?{{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())+1:2):2 This helps track the order of each person within a group, so you can apply a condition like “only reach out if the number is less than 3 Let me know if you want help setting it up!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    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 02 Support.