1

I know I can go here to see my rank in a particular tag. But is there a way to see at what percent I am in?

  • 1
    In short: no such thing. And something similar was asked, though I might have missed your request, in which case please explain better what you want and I will reopen this. – Shadow The Princess Wizard Aug 21 '16 at 18:40
3

The following SEDE query gives you that result:

; with tagleague as 
(
-- build score and count per user
select p.owneruserid
     , sum(score) as score
     , count(*) as posts
     , rank() over(order by sum(score) desc) as tagrank
from posts p  
inner join posttags pt on pt.postid = coalesce(p.parentid, p.id) -- questions have tags
inner join tags t on t.id = pt.tagid
where t.tagname = ##tagname:string?java##
and p.owneruserid is not null
and posttypeid in (1,2) -- Q/A 
group by owneruserid
)

select owneruserid as [User Link]
     , ( cast(tagrank as decimal) 
       / (select count(*) from tagleague) 
       * 100 ) as perc
     , (select count(*) from tagleague) as total
     , tagrank
from tagleague
where owneruserid = ##userid:int?1475228## 

When run today your percentage is:

percentage of ranking in tag

Keep in mind that SEDE is only updated weekly, in the weekend.

  • Wow! Nice. Thanks for the answer. :D – Pritam Banerjee Aug 21 '16 at 23:54

You must log in to answer this question.

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