What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 130 Stack Exchange communities.

I've got a couple of "Top 20%" tags on my careers page. I'd really like to know how far I am from getting the same award for the "android" tag. Is there an easy way to get that information?

I don't think the 'android' Top Users page gives me all the information I need.

share|improve this question
    
It's taken me 24 upvotes to get in the top 30% for [php], and you've got 16 [android] upvotes, so presumably you're not far off from at least getting it onto your CV. –  mmyers Oct 26 '11 at 21:12

2 Answers 2

up vote 7 down vote accepted

I'm certainly no T-SQL expert, but perhaps something like this query is what you're looking for?

According to the query, you were in the top 33% for at the time of last data load if we exclude all users who have score <= 0 in answers under that tag. You fare significantly better if we include those users, so I imagine the real calculation doesn't.

I'm not sure how reliable this approach is, or how closely it represents how Careers makes the determination (they might do it by distribution of total score, for instance, whereas this query does it by ranking; also, they only look at profiles of people on the Careers site), but hopefully it's good enough to give you a rough idea.

share|improve this answer
    
Great answer, the results looks correct to me. It's a shame you missed the bounty by one day or you'd have won it! –  Dan J Oct 31 '11 at 15:11

Your best bet is probably to use the Data Explorer. I spent just a few seconds on this, so it's awful, but perhaps a starting point:

select count(*) from (
    select OwnerUserId, sum(Score) as Total from Posts
    where tags like '%android%'
    ​group by OwnerUserId
    having sum(Score) > 8
) as foo

(From your profile you currently have a score of 8 in the Android tag.)

It returns 2186 results, and if you remove the HAVING clause it returns 32054. That would put you in the top 7%, so it's clearly wrong :P. Top 20% might be based on rep in the tag rather than the score in the tag, or maybe score on answers only, I can't find any info on it, or perhaps my SQL is wrong. But again, it's just a place to start.

share|improve this answer
    
I wondered if they don't count the people with a score of zero in the 'android' tag, but doing that query yields 14580, which would still mean I am in the top 20%. As you say, it might be down to rep in that tag. If somebody could help me with a suitable Data Explorer query that would be great! –  Dan J Oct 12 '11 at 21:22
1  
This query only gets questions, because answers don't have their tags field populated. –  mmyers Oct 26 '11 at 21:17
    
@mmyers Yes, it's probably the worst SQL that actually executes that I've ever written :P –  Matthew Read Oct 27 '11 at 15:11
1  
Well, the schema doesn't exactly make this easy. I for one have no idea how I would write a correct query here. –  mmyers Oct 27 '11 at 15:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .