Caveat above ^^^
SELECT h_resolvedby_user_id, year_week, MAX(resolved_count) AS record FROM (
COUNT(h_pk_reference) as resolved_count,
CONCAT(YEAR(h_datelogged), '/', WEEK(h_datelogged)) as year_week
h_resolvedby_user_id IS NOT NULL
resolved_count DESC ) AS x
GROUP BY x.h_resolvedby_user_id
ORDER BY record DESC
appears to work.
Of course, if you have more than 100 Analysts you will hit the same error, and I have only tried this in Database Direct, so there may be additional factors in a Measure.