Incorrect stats on landing page
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• PMenon-WMF
	Oct 5 2023, 6:11 AM

Description

The stat X people have taken part in Y contests on the WSContest tool is incorrect as the number of people is taken as the total number of users in the user table, which includes admins and users with no contributions/scores.

Query as in code: SELECT COUNT(*) AS tot FROM users

The number of people (X) should be modified to be the number of people who have made contributions and have a valid score to their name.

Event Timeline

• PMenon-WMF created this task.Oct 5 2023, 6:11 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 5 2023, 6:12 AM

I guess something like SELECT COUNT(DISTINCT user_id) FROM scores would be more what we want?

• PMenon-WMF claimed this task.Oct 5 2023, 4:42 PM

• PMenon-WMF moved this task from Backlog to In progress on the tool-wscontest board.

Made a PR here.

This stat is still a bit ambiguous, but it's still a good quick fix!

• PMenon-WMF closed this task as Resolved.Oct 10 2023, 5:43 AM

• PMenon-WMF removed a project: Patch-For-Review.

Incorrect stats on landing pageClosed, ResolvedPublicActions

Description

Event Timeline

Incorrect stats on landing page
Closed, ResolvedPublic
Actions