I'm looking to find the ratio "number of questions from me with accepted answer" divided by "total number of questions from me". This is what I mention as my "answer accept rate" or AAR.

Finding the first number is the goal here because the second one is trivial to find. From my profile one can see that it is 135.


1 Answer 1


Try this query: AAR

A snapshot of result for your account:

enter image description here

  • But why is it showing AAR to be zero? 92/135 is not equal to 0.
    – Rickross
    Jan 22, 2021 at 8:27
  • I tried to get float value, it's always giving an integer. Not sure why. @Rickross
    – TheLittleNaruto Mod
    Jan 22, 2021 at 8:28
  • Okay .. but looks like it is giving the correct results.
    – Rickross
    Jan 22, 2021 at 8:31
  • But the number 92 includes Qs which don't have any answer. Is it possible to know how many such Qs are there where there is at least one answer but no accepted answer?
    – Rickross
    Jan 22, 2021 at 8:36
  • @Rickross Is it? Yeah that should be possible. Let me check.
    – TheLittleNaruto Mod
    Jan 22, 2021 at 8:42
  • Yes it is so the case. Some of my Qs are not answered as of yet.
    – Rickross
    Jan 22, 2021 at 8:46
  • 1
    @Rickross the query already showing float value 0.68.. total Q which have answer is coming 100 after adding 'q.answerCount > 0' in the query..and ratio is 0.92..
    – YDS
    Jan 23, 2021 at 1:23
  • 1
    @YDS I updated my query. :-)
    – TheLittleNaruto Mod
    Jan 23, 2021 at 1:27

You must log in to answer this question.

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