I have more than 5 questions record and running this query on my id (in Unix) says that I have well over 0.5 of "positive question record". But the badge has not been awarded anyway.

What am I missing ?


1 Answer 1


I believe you're missing the deleted questions.

As Michael did previously, I took the apparent formula:

(total questions - negative questions - closed - deleted)/total questions >= 0.5

and plugged in your numbers (according to my interpretation, which counted duplicates as also being closed) and came up with a number less than 0.5. I based my "duplicate" decision on Jon Ericson's comment:

@PRY: I considered making an exception for duplicate questions, but decided that worked against the spirit of the badges. Duplicates sometimes help people find the information they are looking for, but the goal of the badge is to encourage new questions.

I think that badges are awarded on a daily basis, so if my assumptions are wrong, it's also possible that you simply need to wait 24 hours for the next cycle.

Forgot to mention: the query in SEDE may have misled you because it doesn't include deleted posts (e.g. questions), thus hiding some of the factors in the calculation.

  • 1
    Addendum -- I had to click a few times to find it, but the SEDE help page (data.stackexchange.com/help) links to a tutorial (data.stackexchange.com/tutorial) which (on the last page) links to the schema documentation (meta.stackexchange.com/a/2678/307535) which leads to Jon Ericson's post (meta.stackexchange.com/a/266431/307535) which says "At the moment, there's no way to see the ClosedDate, tags or titles of deleted questions. Bodies and the various UserIds are also null for deleted posts, for obvious reasons"
    – Jeff Schaller Mod
    Apr 5, 2020 at 14:07
  • 1
    I am saying both things: SEDE does not show you your deleted posts and you have more than 1 deleted questions. I cannot remember if or how you can see them all yourself. I'm not sure if it's appropriate to link them here, so if you'd like a list of them, please let me know (here or in the chat room) and I can try to create a private chat room to list them for you.
    – Jeff Schaller Mod
    Apr 6, 2020 at 1:31
  • 1
  • @Isaac unix.stackexchange.com/… (the result of going to your profile and adding "is:Q deleted:1" to the user search box) might also help; I just don't remember if it shows you all of your deleted Q's or only the most recent ones.
    – Jeff Schaller Mod
    Apr 6, 2020 at 1:51
  • Socking, just shocking, well, that explains it.
    – user232326
    Apr 6, 2020 at 3:45
  • Yes. it shows all deleted questions, even the ones that someone else has deleted (not me) but belong to me as I asked them.
    – user232326
    Apr 6, 2020 at 4:12
  • @muru Thanks. :-)
    – user232326
    Apr 6, 2020 at 4:16
  • Happy to hear we got to the bottom of it, @Isaac. I edited my comment above to remove the exact number. It's hard to give a good answer to a personal question without going into some level of detail. Let me know if this is all satisfactory. Thanks!
    – Jeff Schaller Mod
    Apr 6, 2020 at 11:15

You must log in to answer this question.