Export to CSV
We have to decide what is the format of the CSV output. I propose to have 1 file per KPI and year (e.g.: EPN2024RI-VESPA-UniqueVisitors-2020.csv
) and then having monthly columns and 1 row per server.
Example file EPN2024RI-VESPA-UniqueVisitors-2016.csv
:
"Server","City,Country","Jan 2016","Feb 2016","Mar 2016","Apr 2016","May 2016","Jun 2016","Jul 2016","Aug 2016","Sep 2016","Oct 2016","Nov 2016","Dec 2016"
"PADC Planetary Server","Paris","France",0.0,0.0,12.0,7.0,8.0,26.0,18.0,29.0,22.0,30.0,32.0,33.0
"PADC Solar Server","Paris","France",0.0,0.0,1.0,0.0,2.0,4.0,1.0,4.0,3.0,5.0,8.0,24.0
[...]