BI: Library Dashboard (CDS)

Library Dashboard (CDS)

The dashboard has to consist of 3 charts:

1. [BI-Library: CDS. Number of CERN Publications, contributions in conference proceedings, Number of CERN publications (other than journals and proceedings)](https://github.com/cern-sis/Library-Notifications-Service/issues/9)
* Description: get the total count of
* Queries:
Number CERN publications
* Query (exchange YYYY with wanted year):
http://cdsweb.cern.ch/search?wl=0&ln=en&cc=Published+Articles&sc=1&p=%28affiliation%3ACERN+or+595%3A%27For+annual+report%27%29+and+year%3AYYYY+not+980%3AConferencePaper+not+980%3ABookChapter+not+595%3A%27Not+for+annual+report%27&f=&action_search=Search
Number of CERN contributions in conference proceedings
* Query (exchange YYYY with wanted year): http://cdsweb.cern.ch/search?wl=0&ln=en&cc=Published+Articles&p=980%3AARTICLE+and+%28affiliation%3ACERN+or+595%3A%27For+annual+report%27%29+and+year%3AYYYY+and+980%3AConferencePaper+not+595%3A%27Not+for+annual+report%27&f=&action_search=Search&c=Published+Articles&c=&sf=author&so=a&rm=&rg=10&sc=1&of=hb
Number of CERN publications (other than journals and proceedings)
* Query (exchange YYYY with wanted year):
https://cds.cern.ch/search?ln=en&p=affiliation%3ACERN+or+260%3ACERN+and+260%YYYY++and+%28980%3ABOOK+or+980%3APROCEEDINGS+or+690%3A%27YELLOW+REPORT%27+or+980%3ABookChapter+or+980%3AREPORT%29+not+595%3A%27Not+for+annual+report%27&action_search=Search&op1=a&m1=a&p1=&f1=&c=Articles+%26+Preprints&c=Books+%26+Proceedings&sf=&so=d&rm=&rg=10&sc=1&of=hb
* Calculations: get all queries separate count and all total count
* Follow up: the last 5 years
* Visualisation: Stacked Bars
* Missing information:
* How often harvest data?

2. [BI-Library: CDS. Ratio of records with fulltext in institutional repository](https://github.com/cern-sis/Library-Notifications-Service/issues/11)
* Missing information:
* How often should we harvest data? Every year? Every quarter?
* Queries?
* Wanted visualization: Line graph

3. [BI-Library: DCS. New items in the institutional repository](https://github.com/cern-sis/Library-Notifications-Service/issues/10)
* Missing information:
* How often should we harvest data? Every year?
* The query for full-text records? The query for not full-text records?
* Wanted visualization: Stacked bars