[export] export of reports
User story
The user should be able to export data about reports. The expected reports are :
For choices field :
- the number of answer by question
Example :
Number of answers | |
---|---|
Answer 1 | 1 |
Answer 2 | 100 |
Answer 3 | 25 |
Answer other | 15 |
TOTAL | 141 |
without answer | 30 |
For number field:
(see #11 (closed))
- print a report with some statistics of answers
stat | |
---|---|
Number of answers | 141 |
Mean of answers | 15 |
Min of answer | 10 |
Max of answer | 5 |
Without answer | 10 |
- print a report of the distribution of number
Example :
Number of answers | |
---|---|
10 | 1 |
15 | 100 |
99 | 25 |
231 | 15 |
TOTAL | 141 |
without answer | 30 |
For other fields (like ICPC2, ...) we should be able to offer the possibility to create some reports.
The user should be able to have a basic filter :
- filter by date of report
- filter by center.
The report should output in a CSV file (minimal), and ods (preferred) and xlsx (if we have time).
User experience
The user click on the Export Menu. He then click on "Export Report". He sees a selector to choose between the created reports.
Then, he has a big form: those are the field :
H1: Export of report
h2: Filter the report
- Period of export: from `date selector` to `date selector` ;
- Centers: `center selector` (only the selector where the user has the role 'statistics'. The selector is expanded = False and multiple = True ;
h2. Select the fields
{% for field in fields %}
if the field is 'choice' :
[ ] repartition of the answers
if the field is 'number' :
[ ] statistic of the answers
[ ] repartition of the answers
if the field is something else:
[ ] for each possibility...
{% endfor %}