Index  | Recent Threads  | Unanswered Threads  | Who's Active  | Guidelines  | Search
 

Quick Go »
No member browsing this thread
Thread Status: Active
Total posts in this thread: 3
[ Jump to Last Post ]
Post new Thread
Author
Previous Thread This topic has been viewed 389 times and has 2 replies Next Thread
Thameshouse
Cruncher
USA
Joined: Jun 5, 2006
Post Count: 16
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
confused Discrepancy between My Contribution Results & Results Page

I've noticed a significant discrepancy between the number of results returned per day showing on my contribution overview page vs downloading a CSV of all results and filtering down to the day.

Example, on 5-13-2024, my contribution page shows 1,340 results returned whereas a CSV download of the results page, filtered down to all results returned on 5-13-2024, shows 2,833. On 5-11-2024, my contribution overview page shows 1,229 and my CSV download of the results page shows 1,249.

Any ideas on what could be causing this?
[May 14, 2024 10:02:41 AM]   Link   Report threatening or abusive post: please login first  Go to top 
adriverhoef
Master Cruncher
The Netherlands
Joined: Apr 3, 2009
Post Count: 2089
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Re: Discrepancy between My Contribution Results & Results Page

Let's have a look.
On my country statistics page my number of results returned yesterday is 1,470.
On my Contribution->History page my number of results returned yesterday is 1,470.
When I download the history.csv from "my activity" it shows:
date,points,results,runtimeInSeconds

2024-05-13,3905152,1470,4744759

Mind you, they are all Valid results.
So far, so good.
On the Results page you should count the number of Valid results on that day.
The format of the history.csv that you can download there is:
appVersionNumber,claimedCredit,cpuHours,deviceName,dueTime,elapsedTime,grantedCredit,os,\
osVersion,owned,resultId,resultName,returnedTime,sentTime,status,statusName,workunitId
Here, returnedTime is the 13th column and statusName the 16th.
So, filtering to the day, you could apply this command:
awk -F, '$13 ~ /^"2024-05-13/ && $16 == "Valid" { print }' history.csv | wc -l
The outcome for me is 1358. The small difference (1470 vs 1358) doesn't worry me, because a (small) number of the returned results will (still) be Pending Validation etc.

Furthermore, you wrote:
Example, on 5-13-2024, my contribution page shows 1,340 results returned whereas a CSV download of the results page, filtered down to all results returned on 5-13-2024, shows 2,833. On 5-11-2024, my contribution overview page shows 1,229 and my CSV download of the results page shows 1,249.

The Valid results from 2024-05-11 will mostly have dropped from your results list as they are deleted from the datababase after two days. Take for example my results from the 11th:
awk -F, '$13 ~ /^"2024-05-11/ && $16 == "Valid" { print }' history.csv | wc -l
My outcome is 64. It's a low number, as expected.

EDIT: added a note about Valid results.

Adri
----------------------------------------
[Edit 3 times, last edit by adriverhoef at May 15, 2024 3:36:40 PM]
[May 14, 2024 1:21:27 PM]   Link   Report threatening or abusive post: please login first  Go to top 
IT022906
Cruncher
Joined: Feb 4, 2005
Post Count: 16
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Re: Discrepancy between My Contribution Results & Results Page

crying I have the same problem from 2 weeks. crying
[May 22, 2024 7:50:12 AM]   Link   Report threatening or abusive post: please login first  Go to top 
[ Jump to Last Post ]
Post new Thread