17
votes
Accepted
Comparison chart of site progress over the years or over the last few months?
One way is to use Internet Archive as discussed here
You can find some snap shots for earlier months and year there.
I've tabulated data from available snap-snots and prepared some charts. That may ...
PandyaMod
- 26k
10
votes
Accepted
How to get list of top users based on number of answers, questions and both?
The following query will show users, total posts, questions, answers, tag excerpts and tag wikis.
select u.id [User Link]
, u.reputation
, u.creationdate
, count(*) [# posts]
, sum(...
- 101
8
votes
Accepted
I need a query for finding out users with high voting rates
I have created a query to get votes per day for particular user. Query is as follows:
DECLARE @UserID int = ##UserId##
select Id as UserId, CreationDate, LastAccessDate, UpVotes, DownVotes,
DATEDIFF(...
- 23.7k
8
votes
How to get list of top users based on number of answers, questions and both?
I could create those queries with the help of some other queries:
https://data.stackexchange.com/hinduism/query/1423034/users-who-contributed-most-posts-qa
https://data.stackexchange.com/hinduism/...
- 24k
7
votes
Accepted
Queries that rank users according to the number of close/reopen votes they have cast
What I have written here is to the best of my knowledge, but I am only a beginner at using the SE data explorer and corrections may be due. I did not write the queries mentioned but only slightly ...
- 435
7
votes
Accepted
Is there a way of determining how many and which users were active on a given day?
You have to define active more precise but I have taken the users that either post or edit or leave a comment and then created this SEDE Query
select activedate
, count(*) [# users]
from
(
...
- 101
7
votes
Accepted
6
votes
Accepted
Can the data "visited-number of days" be known/displayed publicly for any user?
No. It is not available for a normal user. It is available for you and moderators only.
For normal users or when logged out
For the user when logged in the same as you uploaded in the question.
...
- 25.7k
5
votes
Accepted
Query for how many downvotes a user has received so far
There is a query present to find the User Ratio of Upvotes to Downvotes Received.
select
SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS [Up Votes],
SUM(CASE WHEN VoteTypeId = 3 THEN 1 ...
- 23.7k
3
votes
Given any user- how to find out all such tags for which he/she is the top user?
I have edited a query to make it fulfill half of the requirement. By using this query Tags for which user is top answerer. you can get all the tags for which the given user is top answerer.
- 23.7k
2
votes
Comparison chart of site progress over the years or over the last few months?
There is an easier way to check the stats. This is a privilege provided by the Stack Exchange for the users with >5k reputation (Only on beta sites. 25k on normal sites). So, you have to earn all the ...
- 25.7k
Only top scored, non community-wiki answers of a minimum length are eligible