Rank by most used email domain

[SteveFord]

Hi, I'm trying to rank the attached data by most commonly used domain.

[pedrodrfaria]

Hi @SteveFord 

If you already have a count, you can just add a Sort tool afterwards and sort it to create the ranking.

[SteveFord]

Hi, how would I then filter out the domain with the highest number?

[pedrodrfaria · Accepted solution]

I attached the workflow below. Use the sample tool to get the top result.

[danilang · Accepted solution]

Hi @SteveFord 

Since internet domains are not case sensitive, you might want to redo your count after using LowerCase([Email domain])  This will add the single 10XGENOMICS record to the 62 10xgenomics records.  Then you can sort

Dan