# Project summary statistics: stats summary wrong for collection projects **URL:** \ **Category:** General\ **Created:** [June 2, 2023, 12:15pm UTC](https://forum.inaturalist.org/t/project-summary-statistics-stats-summary-wrong-for-collection-projects/42241 "2023-06-02T12:15:40Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![tonyrebelo](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/tonyrebelo/32/317_2.png) [@tonyrebelo](https://forum.inaturalist.org/u/tonyrebelo)\ **Post date:** [June 2, 2023, 12:15pm UTC](https://forum.inaturalist.org/t/project-summary-statistics-stats-summary-wrong-for-collection-projects/42241/1 "2023-06-02T12:15:40Z")
**Platform** (Website): **Browser** , not relevant The statistics page for collections projects does not properly summarize the data. So for trad projects it works (e.g. [https://www.inaturalist.org/projects/habitats-s-afr/stats](https://www.inaturalist.org/projects/habitats-s-afr/stats)) but for collections projects it does not provide a reasonable summary (e.g. [https://www.inaturalist.org/projects/bees-of-south-and-southern-africa/stats](https://www.inaturalist.org/projects/bees-of-south-and-southern-africa/stats)) This delivers: ![image](https://us1.discourse-cdn.com/flex016/uploads/inaturalist/original/3X/9/8/98d716d6df1dd356ea25343ddb1d9e5af561666b.png) Which is clearly wrong as there are 12,933 observations in the project. Is there any chance that this can be restored? It seems counterproductive to download all 12,933 observations just to create a pivot table with observations per year+month. and to do so every month. I dont suppose it might be possible to have it presented as a graph (like so - as is done on the taxon page?) on the statistics page (~?tab=stats)? ![image](https://us1.discourse-cdn.com/flex016/uploads/inaturalist/original/3X/a/9/a96d7b5c8c18e527563f42990dfa9d4726480d29.png) Ta Tony ---
**Author:** ![pisum](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@pisum](https://forum.inaturalist.org/u/pisum)\ **Post date:** [June 2, 2023, 12:51pm UTC](https://forum.inaturalist.org/t/project-summary-statistics-stats-summary-wrong-for-collection-projects/42241/2 "2023-06-02T12:51:56Z")
> [@tonyrebelo](#): > > for collections projects it does not provide a reasonable summary > [@tonyrebelo](#): > > Is there any chance that this can be restored? is this even _supposed_ to work for collection projects? i don’t see any actual links on collection project pages that would take you to such a page. (just because the system does something if you type in a particular URL doesn’t necessarily mean that it’s intended to work.) > [@tonyrebelo](#): > > It seems counterproductive to download all 12,933 observations just to create a pivot table with observations per year+month. and to do so every month. the API does provide this information. for example: [https://api.inaturalist.org/v1/observations/histogram?project\_id=bees-of-south-and-southern-africa&interval=month&date\_field=created](https://api.inaturalist.org/v1/observations/histogram?project_id=bees-of-south-and-southern-africa&interval=month&date_field=created) (you can change the parameters in the URL to get the information you’re most interested in…) here’s a page that will get and present that information as a bar chart and table: [https://jumear.github.io/stirfry/iNatAPIv1\_observation\_histogram?project\_id=bees-of-south-and-southern-africa&interval=month&date\_field=created](https://jumear.github.io/stirfry/iNatAPIv1_observation_histogram?project_id=bees-of-south-and-southern-africa&interval=month&date_field=created). or you can work with the data in whatever tool you prefer. - here’s an explanation of how to work with this kind of data in Excel: [https://forum.inaturalist.org/t/using-excel-api/22378#step-5-optional-column-chart-of-observations-by-day](https://forum.inaturalist.org/t/using-excel-api/22378#step-5-optional-column-chart-of-observations-by-day) - here’s an example of an R script to work with that sort data: [https://forum.inaturalist.org/t/1m-observations-this-month/2582/4](https://forum.inaturalist.org/t/1m-observations-this-month/2582/4) - you can search for the forum for more examples: [https://forum.inaturalist.org/search?q=http%3A%2F%2Fapi.inaturalist.org%2Fv1%2Fobservations%2Fhistogram](https://forum.inaturalist.org/search?q=http%3A%2F%2Fapi.inaturalist.org%2Fv1%2Fobservations%2Fhistogram) ---
**Author:** ![tiwane](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/tiwane/32/54612_2.png) [@tiwane](https://forum.inaturalist.org/u/tiwane)\ **Post date:** [June 2, 2023, 4:58pm UTC](https://forum.inaturalist.org/t/project-summary-statistics-stats-summary-wrong-for-collection-projects/42241/3 "2023-06-02T16:58:02Z")
> [@pisum](#): > > is this even _supposed_ to work for collection projects? To my knowledge it’s not designed to work for collection projects, so it’s not a bug. ---
**Author:** ![tonyrebelo](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.inaturalist.org/tonyrebelo/32/317_2.png) [@tonyrebelo](https://forum.inaturalist.org/u/tonyrebelo)\ **Post date:** [June 3, 2023, 9:43am UTC](https://forum.inaturalist.org/t/project-summary-statistics-stats-summary-wrong-for-collection-projects/42241/4 "2023-06-03T09:43:24Z")
Thanks, the histogram api option is great. (And the date created rather than observed is what I really wanted) Except that given that the functionality exists (on the taxon page), might it not be useful to include the histogram on the stats tab too? Would I be wasting my time suggesting this as a new feature? ---
**Author:** ![pisum](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@pisum](https://forum.inaturalist.org/u/pisum)\ **Post date:** [June 3, 2023, 12:15pm UTC](https://forum.inaturalist.org/t/project-summary-statistics-stats-summary-wrong-for-collection-projects/42241/5 "2023-06-03T12:15:16Z")
> [@tonyrebelo](#): > > Would I be wasting my time suggesting this as a new feature? you never know, but i would guess that even there was some interest from others in this sort of feature, it would not be implemented anytime soon. i just remembered that sort of within the system already, there is the Experimental Compare tool, which can also help you graph the histogram data: [https://www.inaturalist.org/observations/compare](https://www.inaturalist.org/observations/compare). you’ll notice that the URL changes with whatever configurations you make on that page, and once you have the configuration you like, you can save that URL and add it as a link on your project page. that might be the best you’ll get for a while. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex016/uploads/inaturalist/original/2X/7/7831452cf7f0d653ff1ffd34176334b7ef1b6a17.png) [@system](https://forum.inaturalist.org/u/system)\ **Post date:** [August 2, 2023, 12:15pm UTC](https://forum.inaturalist.org/t/project-summary-statistics-stats-summary-wrong-for-collection-projects/42241/6 "2023-08-02T12:15:30Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.