Enable community and collection "statistics" reports in Excel

[alanorth]

We would like to be able to generate usage reports for communities and collections in Excel format, for example:

Collection name	Views	Downloads
ILRI Articles in Journals	1000	1500
ILRI Presentations	344	100

Right now if we select a community or collection in the search filters and generate a report we will get a list of all items in those communities/collections. Is there a way to "collapse" the report to just show the sub-communities/collections? All items have a list of their parent communities and collections already.

[alanorth]

For this one, the DSpace Statistics API now has the ability to report community and collection numbers, see the Swagger API docs. You can get all-time stats with a GET request, or POST a list of community/collection UUIDs with a date range to get statistics for a reporting period.

For example, if you POST this to /rest/statistics/communities:

{
  "limit": 100,
  "page": 0,
  "dateFrom": "2020-01-01T00:00:00Z",
  "dateTo": "2020-12-31T00:00:00Z",
  "communities": [
    "bde7139c-d321-46bb-aef6-ae70799e5edb",
    "8a8aeed1-077e-4360-bdf8-a5f3020193b1",
    "47d0498a-203c-407d-afb8-1d44bf29badc",
    "d3fe99a9-e27d-4035-9339-084c93228c82"
  ]
}

The API will respond:

{
  "currentPage": 0,
  "totalPages": 1,
  "limit": 100,
  "statistics": [
    {
      "id": "bde7139c-d321-46bb-aef6-ae70799e5edb",
      "views": 376526,
      "downloads": 668815
    },
    {
      "id": "47d0498a-203c-407d-afb8-1d44bf29badc",
      "views": 367950,
      "downloads": 344526
    },
    {
      "id": "8a8aeed1-077e-4360-bdf8-a5f3020193b1",
      "views": 81955,
      "downloads": 390944
    },
    {
      "id": "d3fe99a9-e27d-4035-9339-084c93228c82",
      "views": 81153,
      "downloads": 139843
    }
  ]
}