We want to identify potential editors for a specific client. In order to be considered, these vendors must already have worked on 50 or more translation or transcription jobs for this client. I'm having trouble pulling this data.
In the Vendors module, I can find vendors who have done at least 50 jobs, including at least one job for this client. This means that I'll sometimes find vendors who have done more than 50 jobs but only one or two jobs for the client. I don't want them to appear in my search because they aren't qualified to be considered for editing.
In Projects > Jobs, I can find all the jobs a vendor has done for this client, but it's time-consuming to tally the number of jobs per vendor.
How can I find vendors who've done 50 or more jobs for this specific client? Thanks.
Customer support service by UserEcho