17

Referring to here: https://stackexchange.com/sites#users

enter image description here

Hovering over the questions/day I see per day on average over the last 2 weeks.

But where/how is this actually calculated (formula, etc.)? I'm hoping for the details similar to how Kevin answered here: How is views/day calculated?

6
  • 1
    Not even close to an answer @Servy. Not even a decent comment. Does it include migrated from questions? Migrated to questions? There's more to it than you state otherwise the data.stackexchange.com site would easily retrieve it with posttypeid=1.
    – TheCleaner
    Oct 10, 2013 at 13:59
  • 1
    @Servy select count(*) / 14 from Posts where CreationDate >= dateadd(day, -13, datediff(day, 0, getdate())) and PostTypeId=1 returns 4531
    – Stijn
    Oct 10, 2013 at 14:33
  • 1
    @Stijn The data explorer doesn't have very up to date results. Just run select Max(CreationDate) from Posts where PostTypeId=1 I got 2013-10-06 06:54:37 When you're missing several days worth of data obviously it won't match.
    – Servy
    Oct 10, 2013 at 14:38
  • @Servy: I'm guessing that a query corrected to take account the date that the data was dumped also doesn't give a reasonable answer - I'm sure you'd have take great pleasure in showing us had it done so ;)
    – user147520
    Oct 10, 2013 at 16:02
  • @Iain Well, you'd have to actually do that. How do you know that it won't match?
    – Servy
    Oct 10, 2013 at 16:06
  • @Servy: No, I couldn't do it I don't have the skills but if I did and I'd gone to the trouble of doing what you did I'd definitely have run the query and posted the result unless ...
    – user147520
    Oct 10, 2013 at 16:07

1 Answer 1

7

What the Stats Say

Questions per Day

We want to find a number matching 7,176 questions per day over the past two weeks.

Simple Search

I searched for all questions created in the past two weeks (October 1st through October 14th) with this simple search.

This returns 100,489 questions.

Dividing by 14 to get the daily answer, we get 7,177.786/day, which is 2/day above our target.

If we extend the search to October 15th we get 100,988 posts.

Conjecture

The calculation is not for full days, but for hours. Rather than searching by day, it is likely searching for posts made over the past 336 hours.

Since the standard search does not include deleted posts, chances are that deleted posts are excluded.

I believe Migrated posts are also excluded as well.

2
  • 1
    Thanks jmac. meta.serverfault.com/a/5887/7861 is an "official" answer btw (albeit still a little fuzzy, but ok). It doesn't count deleted but does count closed. I like how you explained how you searched though, since numerous attempts on the data.stackexchange.com didn't work. Thanks again.
    – TheCleaner
    Oct 15, 2013 at 13:03
  • Yeah, this isn't official or intended to be (note the 'conjecture' titling), but it was close. I'm glad it was of some use.
    – jmac
    Oct 15, 2013 at 14:34

You must log in to answer this question.

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