How do I find out how hot I am? Is there an easy-to-see user's total HNQ (total hotness) counter?

Question

I noticed a that recently it seems that at least one of my questions have gone to the HNQ each week, though they are asked on different sites.

But I don't know how to verify this.

Is there a "total user hotness" function, something that shows how many of my questions have been HNQ this week or this month as a plot or numbers?

Answer 1

SE broke peterh's SEDE query to see the HNQ count network-wide for all users. I forked it and fixed: https://data.stackexchange.com/stackoverflow/query/1682302

CREATE TABLE #output (
  dbname VARCHAR(max),
  UserName NVARCHAR(40),
  SEAccountId INT,
  HnqCount INT
);

DECLARE @query VARCHAR(MAX);

DECLARE dbcursor CURSOR FOR
SELECT name
FROM sysdatabases
WHERE name NOT IN ('master', 'tempdb', 'model' ,'msdb', 'Data.StackExchange','Worldbuilding_Temp','Meta_Temp','StackOverflow.Meta_Temp.dbo','Expatriates_Temp','StackExchange.Softwarerecs_Temp')
AND name NOT LIKE '%_Temp';

DECLARE @dbname VARCHAR(max);

OPEN dbcursor;
FETCH NEXT FROM dbcursor INTO @dbname;

WHILE @@FETCH_STATUS = 0
BEGIN
  SELECT @query = '
    SELECT
      ''' + @dbname + ''' AS dbname,
      MIN(Users.DisplayName) AS UserName,
      Users.AccountId AS SEAccountId,
      COUNT(*) AS HnqCount
    FROM
      [' + @dbname + '].dbo.Users,
      [' + @dbname + '].dbo.Posts,
      [' + @dbname + '].dbo.PostHistory
    WHERE
      PostHistory.PostHistoryTypeId = 52
      AND
      PostHistory.PostId = Posts.Id
      AND
      Posts.OwnerUserId = Users.Id
    GROUP BY Users.AccountId
    ';
  INSERT INTO #output EXEC (@query);
  FETCH NEXT FROM dbcursor INTO @dbname;
END

CLOSE dbcursor;

WITH Raw AS (
  SELECT
    SUM(HnqCount) AS HnqCount,
    MIN(UserName) AS UserName,
    SEAccountId
  FROM #output
  GROUP BY SEAccountId
)
SELECT
  DENSE_RANK() OVER (ORDER BY HnqCount DESC) AS Rank,
  UserName,
  SEAccountId,
  HnqCount,
  'http://stackexchange.com/users/'
    + CAST(SEAccountId AS VARCHAR(30))
    + '?tab=accounts|' + UserName AS 'SE Profile',
  'https://data.stackexchange.com/stackoverflow/query/678540?AccountId='
    + CAST(SEAccountId AS VARCHAR(30)) + '#resultSets|' + UserName
    AS [With Hidden Accounts]
FROM Raw
ORDER BY HnqCount DESC, SEAccountId;

Answer 2

We do not have any sort of counter for this anywhere on the network, not on a per-site or network wide basis... though that's not because it's not potentially interesting information. We didn't track whether a question was on the HNQ list until February 2019, so creating a feature like this wasn't possible until then.

That said, if we ever did create it, it'd be very incomplete as we can't create the data looking backwards before February. We just don't have the information. So, any tool would come with the giant asterisk "Data since February 2019".

If you are interested in the partial data you can probably do this in SEDE by requesting the count/site for the appropriate history event - I'm a bit sketchy on how such a query would work but there are some users here on MSE who are great with SEDE and may be able to help you with it.