NuGet / NuGetGallery

NuGet Gallery is a package repository that powers https://www.nuget.org. Use this repo for reporting NuGet.org issues.
https://www.nuget.org/
Apache License 2.0
1.54k stars 645 forks source link

[Feature] Show total numbers on the package stats page in addition to 6 week figures #9236

Open juaguirre opened 2 years ago

juaguirre commented 2 years ago

Impact

It's more difficult to complete my work

Describe the bug

I work at Microsoft Azure Cloud Marketplace, I am in charge of developing download analytics for this package https://www.nuget.org/packages/Marketplace.SaaS.Client The problem I am having is in the front page shows 52 per day downloads However when I enter the "full stats" link which provides 6 weeks rolling total I see a totally different figure of 4360 downloads which converted to daily would be around 104 which is the double what I would expect of 52. How's so? Thanks in advance for any help! Juan

Repro Steps

Go to https://www.nuget.org/packages/Marketplace.SaaS.Client Take note of "downloads per day" figure Click "full stats" link Compare the figure in the front page i.e. 52 with the total 6-week downloads figure i.e. 4360 divide it by 42 to get the daily downloads figure you will see the big mismatch, today was double 52 vs 104!!

Expected Behavior

I would expect to see 104 as the daily downloads figure in the front page.

Screenshots

msedge_YE6cjdHpcL msedge_2Z8Kdaw7zx

Additional Context and logs

I suspect the figure of 52 is HALF of what it should be of 104

joelverhagen commented 2 years ago

The "per day average" you see on the main package details page is TOTAL_DOWNLOADS / DAYS_SINCE_FIRST_VERSION. So 18.8K divided by 359 (days since 2021-09-19). This rounds to 52, as of today (2022-09-13).

The math you're doing on the stats page is totally different because it's for only download counts for the past 60 days instead of the past 359 days.

I hope this helps.

side note: Assuming this is an official Microsoft package, please note that there are certain guidelines we encourage Microsoft teams to follow for NuGet package ownership, signing, and other metadata. Please access aka.ms/nuget from your corporate account to understand the guidelines this so your package can the shared quality standards we have for official Microsoft packages. (contact us directly for further questions instead of on GitHub since this is essentially an internal conversation not necessarily public facing).

juaguirre commented 2 years ago

Hi Joel,

Thanks a lot for your response now its more clear to me however IMHO it would be great to have TOTAL download figures in addition to only 6-weeks rolling totals, when clicking the “full stats” link which is for that very reason a misnomer as currently total downloads only appear at front page and they do so with no detail, and with limited resolution i.e. 18.8K (resolution of 1/100)

My current project involves analyzing accumulated, daily and YTD download counts, therefore it is difficult to do so with currently available data.

Best Regards,

Juan L Aguirre - WIPRO Data Analyst / Power BI @.**@.> SMS +1 5127396096

@.***

From: Joel @.> Sent: Tuesday, September 13, 2022 5:28 PM To: @.> Cc: Juan Aguirre (WIPRO @.>; @.> Subject: Re: [NuGet/NuGetGallery] [NuGet.org Bug]: Front Page Download Stats Does not Match 6 week Figures (Issue #9236)

The "per day average" you see on the main package details page is TOTAL_DOWNLOADS / DAYS_SINCE_FIRST_VERSION. So 18.8K divided by 359 (days since 2021-09-19). This rounds to 52, as of today (2022-09-13).

The math you're doing on the stats page is totally different because it's for only download counts for the past 60 days instead of the past 359 days.

I hope this helps.

side note: Assuming this is an official Microsoft package, please note that there are certain guidelines we encourage Microsoft teams to follow for NuGet package ownership, signing, and other metadata. Please access aka.ms/nuget from your corporate account to understand the guidelines this so your package can the shared quality standards we have for official Microsoft packages. (contact us directly for further questions instead of on GitHub since this is essentially an internal conversation not necessarily public facing).

— Reply to this email directly, view it on GitHubhttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FNuGet%2FNuGetGallery%2Fissues%2F9236%23issuecomment-1246085110&data=05%7C01%7Cv-juaguirre%40microsoft.com%7Ce9915c78f6a64a7cb26508da95e800f4%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637987120931765947%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=DuX%2BTVPwcryWUTxiCwsIgFeafeGIbZQm8tpHKhIhPYQ%3D&reserved=0, or unsubscribehttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FA3BZOIGJ75AEPJEUVUPX3NTV6ELZVANCNFSM6AAAAAAQL42IRQ&data=05%7C01%7Cv-juaguirre%40microsoft.com%7Ce9915c78f6a64a7cb26508da95e800f4%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637987120931765947%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ksPFbgUTNllOBubInlT02OdQ6vnidyYGRtjI%2F7Ys6co%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.***>

joelverhagen commented 2 years ago

Sure, sounds good. I have updated the title of this issue to reflect your feature request.

juaguirre commented 2 years ago

That’s great Joel thank you very much!

Best Regards,

Juan L Aguirre - WIPRO Data Analyst / Power BI @.**@.> SMS +1 5127396096

@.***

From: Joel @.> Sent: Thursday, September 15, 2022 10:27 AM To: @.> Cc: Juan Aguirre (WIPRO @.>; @.> Subject: Re: [NuGet/NuGetGallery] [Feature] Show total numbers on the package stats page in addition to 6 week figures (Issue #9236)

Sure, sounds good. I have updated the title of this issue to reflect your feature request.

— Reply to this email directly, view it on GitHubhttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FNuGet%2FNuGetGallery%2Fissues%2F9236%23issuecomment-1248397789&data=05%7C01%7Cv-juaguirre%40microsoft.com%7Cb3476da09c4f4a00b4aa08da973f8ef2%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637988596491404841%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=5emLeDhkZk6J6fqDql3kGVe1N%2BbesoyVbZKbmCcZsPg%3D&reserved=0, or unsubscribehttps://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FA3BZOIA3YP6FRBB5RVYQSS3V6NL75ANCNFSM6AAAAAAQL42IRQ&data=05%7C01%7Cv-juaguirre%40microsoft.com%7Cb3476da09c4f4a00b4aa08da973f8ef2%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637988596491404841%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2FRMG2my3hpaEZGnNAqbMemVAUp0HVJ3fpHy4CcyYwiM%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.***>