Data Explorer (SEDE)

« first day (36 days earlier) ← previous day next day → last day (2072 days later) »

4:54 AM

There are two problems with that query, as it now stands. (1) The graph shows 'count', 'tagcount', and 'perc', all on one scale, even though 'perc' is incomparable with both of the other two. (2) More importantly, the percentage figures themselves are surely too low, if you compare them for instance with Martin's table. Later (when I've had more sleep myself!) I must make sure I understand exactly what is being counted - I seem to recall that it is questions created during the month in question.

1 hour later…

Martin

6:21 AM

Aug 28 at 16:17, by rene

the first column either needs to be a date or a number and its values go on x-axis, all other columns go as Y-values

To get graph which only show perc, it suffices to remove count and tagcount from select - see above.

If you check the search on the site, 1006 seems to be the correct number for questions with either of the tags in January 2016: math.stackexchange.com/…

However total number of the questions should be 13583 and not 32548 math.stackexchange.com/…

There is 32530 total posts: math.stackexchange.com/…

Is perhaps the problem that the query counts all post (questions and answers) rather than answers?

@CalumGilhooley I have simply added where p.PostTypeId=1 to the first part: Percentage of questions in given tags per month

If I search on the site, I get in January 2016: 1006 questions and 13583 total questions.

In February 2016 1151 questions and 14300 total questions.

If you want only percentage in graph, you can simply omit other columns in the last select statement: data.stackexchange.com/math/query/893639/…

1 hour later…

Feeds

7:35 AM

Q: Improvements to 'Data updated x hours/days ago' message in SEDE

At the moment of posting this, the SEDE homepage says it has been updated one hour ago: However, when I try to execute a cross-site database query, it runs into an error: According to Taryn's comment, The job is scheduled to start at 3am UTC and runs for about 5 hours, so probably just ...

rene

7:47 AM

@Martin yeah, it was late. Thanks for fixing that

Martin

No problem.

If I understand it correctly, in the other parts specifying postTypeId is not needed - since for answers the condition on tags will never be matched.

rene

8:02 AM

yeah, that is correct

@Feeds I think it actually failed on the Stack Overflow job, probably a size issue but the SRE team will have an e-mail in their mailbox for Monday.

Looking at how we get to that LastDate I don't actually think it is fixable without taking extra dependencies.

I would like to know how the row in the sites table gets updated when sp_refresh_database.sql has run.

6 hours later…

Feeds

2:23 PM

Q: Is there a way to find all interactions with a specific user?

Is there a query that allows me to find all the posts where there are interactions between me and another user? By "interactions" I mean: Their answers to / comments on my questions. My answers to / comments on their questions. Any comments on other posts that include @user (by me) or @me (by ...

support data-explorer

Calum Gilhooley

2:43 PM

@Martin and @rene (does that @ also work?): A monthly graph of the percentage of questions tagged with 'probability' and/or 'statistics' since July 2010 seems informally to show an increase from Oct 2015, and another (smaller, and less evident) from Oct 2017, although there is admittedly no evidence of an increase from Apr 2018.

rene

yep that @-mention came in loud and clear

@Feeds provided another on-site dupe. I might have one on MSE as well

Calum Gilhooley

3:03 PM

@Martin and @rene, re: "A statistical question about statistical questions": on reviewing my personal records, I see that I was actually almost inactive on MSE from early December last year - not just from April this year - so it is likely that if there has been a real increase in the frequency of probability/statistics questions since around October last year, then that is what I was noticing.

1 hour later…

Feeds

4:05 PM

Q: Why does this simple Data Explorer query only return 124 rows instead of 4,912?

Why does this query only return 124 rows when https://stackoverflow.com/users/470749/ryan?tab=votes&sort=all says "4,912 Votes Cast"? SELECT v.id, v.VoteTypeId, v.CreationDate FROM Votes v WHERE v.UserId = 470749 ORDER BY v.CreationDate DESC I must be misunderstanding something. I know that i...