Is there a total score for the whole Stack Exchange stack?

Question

On some days, I'd like to see a summary of my learning & share the knowledge achievements in total, regardless the topic.

Closest thing I found is going to the Stack Exchange Network Profile and hitting the "accounts" tab - https://stackexchange.com/users/2058265/jave-web?tab=accounts + little coding myself.

Still though, everything there, including the graph on the other tab, is by topic.

Is there somewhere a total score page combining every precious stat from all Stack Exchange Network sites - all points, coins, badges, reputations, impact, questions, answers, ...?

Answer 1

The closest you can get to what you want in one place without writing your own code is the global flair:

The global flair sums the reputation and badges on all sites where you have 200 reputation or more.

Getting to see your own flair is pretty simple:

1. Go to your network profile (either directly from this link or by clicking "network profile" link in any of your site profiles)
2. Go to the "flair" tab, the right-most tab in the page. (visible only when viewing own profile)
3. Profit.

To see the flair of other user (like I did with yours, above) it's bit more tricky:

1. Find the user's network profile ID, by going to their network profile (accessibly from any site profile) and taking it from the URL. (the number after the https://stackexchange.com/users/)

2. Manually put the number in this URL:

   https://stackexchange.com/users/flair/[network ID here].png

3. Browse to the above URL or use in image tag/markdown to see the flair of the other user.

Answer 2

You can use the Stack Exchange Data Explorer to query for some 'categories'.

I've combined the most common data that is available and is not anonymized. The query can be extended by adding extra unions.

declare @sql nvarchar(max)

create table #dbs( name nvarchar(max)
                 , userid int)

select @sql = 'insert into #dbs ' + string_agg(concat(
N' 
select ''',convert(nvarchar(max),quotename(name)),N''' [site]
    , id
from ', convert(nvarchar(max),quotename(name)), N'.dbo.users u 
where u.accountid = ##accountid?2058265##
')
,N' union all ')
from sys.databases
where database_id > 5

exec (@sql)




select @sql = concat(N'
select name [Category] 
     , sum([cnt]) [Grand total per cat.]
from (' ,
string_agg(concat(
N'
select ''', name ,N''' [site]
    , pt.Name 
    , count(*) [cnt]
from ', name, N'.dbo.posts p
inner join ', name , N'.dbo.posttypes pt 
      on pt.id = p.posttypeid
inner join ', name , N'.dbo.users u 
      on u.id = p.owneruserid
where p.owneruserid = ', userid, N'
group by name
union all
select ''',name ,N''' [site]
    , vt.Name 
    , count(*) [cnt]
from ', name, N'.dbo.votes v
inner join ', name, N'.dbo.votetypes vt 
      on vt.id = v.votetypeid
where v.userid = ', userid, N'
group by name
union all
select ''',name,N''' [site]
    , case b.class 
      when 1 then case when b.tagbased = 1 then ''Gold Tag badge'' else ''Gold badge'' end 
      when 2 then case when b.tagbased = 1 then ''Silver Tag badge'' else ''Silver badge'' end
      when 3 then case when b.tagbased = 1 then ''Bronze Tag badge'' else ''Bronze badge'' end
      end 
    , count(*) [cnt]
from ', name, N'.dbo.badges b
where b.userid = ', userid, N'
group by b.class, b.tagbased
union all
select ''',name ,N''' [site]
    , ''Comments ''
    , count(*) [cnt]
from ', name, N'.dbo.comments c
where c.userid = ', userid, N'
union all
select ''',name ,N''' [site]
    , ''Upvotes cast''
    , upvotes [cnt]
from ', name, N'.dbo.users u
where u.id = ', userid, N'
union all
select ''',name ,N''' [site]
    , ''Downvotes cast''
    , downvotes [cnt]
from ', name, N'.dbo.users u
where u.id = ', userid, N'
union all
select ''',name ,N''' [site]
    , ''Reputation''
    , reputation [cnt]
from ', name, N'.dbo.users u
where u.id = ', userid, N'
union all
select ''',name ,N''' [site]
    , ''Suggested edits''
    , count(*) [cnt]
from ', name, N'.dbo.suggestededits s
where s.owneruserid = ', userid, N'

')
,N' union all ')
, N') data
group by name
order by 2 desc
')
from #dbs

print @sql
exec (@sql)

When run today this is the result for your account:

Keep in mind SEDE is updated once a week, on Sunday. Give a big shout-out to Monica Cellio for the awesome SEDE Tutorial she wrote.
Say "Hi" in SEDE chat.