.png){kind=logo}
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?
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
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!
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