Update counting queries for multiple centers and research fields (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, the toolbox writes information into both fields "Publisher_deprecated" "publisher_has_publication" (or similar) where the latter can have multiple entries for a single data publication. (addressed in a separate issue)

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

Multiple centers

• 1. in the second figure of "Data in Helmholtz":
  • datasets associated to multiple centers are sorted into category "Multiple". Each Data-DOI is counted only once, even if it is associated to multiple centers.

(manually manipulated muckup example:)

• 2. For all other plots (Figure 1 on the page "Welcome"; Figures 1,2,3 on the page "Data in Helmholtz"; Figures 1, 3 on the page "Repositories";

  • the numbers should not change with respect to the status we have with the current counting method. This means: each data DOIs is counted only once and for the scores are averaged over unique data DOIs only (no multiple averaging over the same data DOI).

• 3. In Figure 1 on the page "Welcome" all numbers of literature- and data publications should NOT change with respect to the status we have with the current counting method. This means: each DOI is counted only once.

Multiple research fields

• 4. in the first figure of "Data in Helmholtz":
  • if the filter is set to "All research fields":
    • datasets with multiple research fields assigned are sorted into category "Multiple". Each Data-DOI is counted only once, even if it is associated to multiple research fields.
  • if the filter is set to a specific research field:
    • the counting is done as usually, where data DOIs are counted once for each associated research field.

(manually manipulated muckup example:)

• 5. in the first figure of "Repositories", datasets with multiple research fields assigned are sorted into category "Multiple". Each Data-DOI is counted only once. (on this page, no filter for research fields exists).

(manually manipulated muckup example:)