Update counting queries for multiple centers and/or research fields and/or publishers (test before merge)

• ✅ table "center_has_publication" already existing.
• ✅ table "research_field_has_publication" already existing.
• ❗ testing requires reharvesting / processing data after toolbox updates

---

in general, for a single data publication, the toolbox part can write

• multiple entries in the table "center_has_publication" (or similar).
• multiple entries in the table "research_field_has_publication" (or similar).

Moreover, as soon as in the toolbox part we move on from field "Publisher_deprecated" to a combination of tables "publisher" and "publisher_has_publication" (or similar) the latter can have multiple entries for a single data publication.

Please make sure, that the following specifications, sorting into "Multiple ...", acts only on the level of the plot, not on that of the filter menus.

To avoid potential over- or under-counting in the dashboard, please change counting queries in the dashboard such that:

• 1. in the first figure of "Data in Helmholtz", datasets with multiple research fields assigned are sorted into category "Multiple research fields".

(manually manipulated muckup example:)

• 2. in the first figure of "Repositories", datasets with multiple research fields assigned are sorted into category "Multiple research fields".

• 3. in the second figure of "Data in Helmholtz", datasets with multiple publishers assigned are sorted into category "Multiple publishers".

(manually manupulated muckup example:

• 4. in the second figure of "Repositories", datasets with multiple centers assigned are sorted into category "Multiple centers".

(manually manupulated muckup example: