Clay Icon

Extracting Top 5 Domain Appearances from a Sorted Table

ยท
ยท

Is there a way to extract the top 5 appearances of a particular domain in a table that's sorted from high to low already?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Yes, you can extract the top 5 appearances by using the Filter and Sort features:1. First, ensure your table is sorted by the desired column: โ€ข Click "Sort" above the table โ€ข Select your column โ€ข Choose "9 โ†’ 0" for descending order (high to low) 2. Then use the Filter feature to limit your view: โ€ข Click "Filter" above the table โ€ข Select the domain column โ€ข Choose "equal to" and enter the domain you want to trackThe resulting view will show you the top appearances of that domain in descending order. Source: Hide, Re-order, Sort, Filter, Merge Columns

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Mark L.
    Mark L.
    ยท
    ยท

    Timo, how are you defining "top 5" in this context? Five most frequently appearing? Or some other metric? If you need a rough rank by count, I set up an example of how you can do that here. See the "Lookup Multiple Rows..." column to the right of the Company Domain. https://app.clay.com/workspaces/138966/workbooks/wb_4xFNM2UAz6bA/tables/t_NFuAk4AsYr8d/views/gv_nqMXkoFuCUWb It's not perfect โ€“ cells will only hold so much data, so I had to put a limit on number of records returned. I capped the records at 20, and the count stops at 100. But you can see how there are some clear stand-outs โ€“ a few domains with 100(+) matches โ€“ and others with 8, 9, 18, 70, etc.. Cheers -Mark

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Timo Y.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: