Rex Dri issueshttps://gitlab.utc.fr/rex-dri/rex-dri/-/issues2020-06-14T19:16:22Zhttps://gitlab.utc.fr/rex-dri/rex-dri/-/issues/192Stats explorer2020-06-14T19:16:22ZFlorent ChehabStats explorerFollowup to #184
We are close to having the following data collected everyday on REX-DRI:
1. How many users connected to the plateforme, with a 24h granularity.
2. Information about exchange related contributions with a 24h granulari...Followup to #184
We are close to having the following data collected everyday on REX-DRI:
1. How many users connected to the plateforme, with a 24h granularity.
2. Information about exchange related contributions with a 24h granularity.
## Example data
Here is a preview how what the two tables might contain:
1. ex:
| *id* | date | nb_connections |
| ---- | ------------------------- | -------------- |
| 1 | 2020-05-01T00:00:00:0001Z | 5 |
| 2 | 2020-05-02T00:00:00:0001Z | 10 |
| 3 | 2020-05-03T00:00:00:0001Z | 3 |
2. ex:
| *id* | date | major | minor | exhange_semester | university | nb_contributions |
| ---- | ------------------------- | ----- | ----- | ---------------- | ---------- | ---------------- |
| 1 | 2020-05-01T00:00:00:0001Z | IM | CMI | P2020 | EPFL | 2 |
| 2 | 2020-05-01T00:00:00:0001Z | IM | MAT | A2020 | EPFL | 1 |
| 3 | 2020-05-03T00:00:00:0001Z | GI | FDD | A2020 | Tokyo | 1 |
*N.B. 'university' will actually be a foreign key to the univ model in the database.*
## Objectives
Those tables enable us to answer the following questions:
1. Questions:
* How many user connected to the site in the last 30 days?
* How many user connected to the site between date1 and date2?
* Can we plot the number of user that connected to site between date1 and date2?
* Etc.
2. Questions (here there are a lot of possibilities -- plus either count or plot):
* How many exchange related contributions between date1 and date2?
* What is the distribution of contributions between majors?
* ... between minors inside a major?
* etc. etc. etc.
## Technical feasibility
### Request
In the frontend, we want to:
* Be able to plot data or display it as a table,
* Be able to export tables as CSV,
* Be able to filter data,
* Be able to "groupby" data,
* Be able to combine the last two settings in whatever configuration,
* Be able to share a reproductible page (filter, groupby, etc.) only with a URL.
### Constraints
* There are a lot of filtering/groupby possibilities, our tool has to be generic enough to cover every possibility.
* The solution should be highly maintainable.
* We must have a strict control about what query is performed in the database.
* We can assume that the end user has some data wrangling knowledge.
* It should be implementable under ~2 weeks.
### Conclusion
How to do it?PR-P20Estelle VeisemburgerEstelle Veisemburgerhttps://gitlab.utc.fr/rex-dri/rex-dri/-/issues/177Filter: give more suggestions & merge IM, GSM, GM ?2020-05-24T18:53:21ZFlorent ChehabFilter: give more suggestions & merge IM, GSM, GM ?> Dans la recherche, si je commence à taper « IM » dans le filtre par branche, seules quelques filières apparaissent. Je ne trouve pas « IM-CMI ». Il faut taper CMI pour faire apparaître IM-CMI et GSM-CMI (nécessité de garder les deux ?)> Dans la recherche, si je commence à taper « IM » dans le filtre par branche, seules quelques filières apparaissent. Je ne trouve pas « IM-CMI ». Il faut taper CMI pour faire apparaître IM-CMI et GSM-CMI (nécessité de garder les deux ?)PR-P20Estelle VeisemburgerEstelle Veisemburgerhttps://gitlab.utc.fr/rex-dri/rex-dri/-/issues/175map: add legend2020-04-25T16:44:44ZFlorent Chehabmap: add legendAdd legend to explain what are the two colors.
* [ ] Create a legend component
* [ ] Overlay on top of the map
* [ ] Works for both in dark and light mode
![Screenshot_from_2020-04-04_12-56-46](/uploads/00f54ed50444817f8103ca5289e8a7f7...Add legend to explain what are the two colors.
* [ ] Create a legend component
* [ ] Overlay on top of the map
* [ ] Works for both in dark and light mode
![Screenshot_from_2020-04-04_12-56-46](/uploads/00f54ed50444817f8103ca5289e8a7f7/Screenshot_from_2020-04-04_12-56-46.png)
PR-P20Estelle VeisemburgerEstelle Veisemburgerhttps://gitlab.utc.fr/rex-dri/rex-dri/-/issues/159Fix useless READ MORE markdown2020-05-03T15:45:13ZFlorent ChehabFix useless READ MORE markdownIn some cases, the "Read more button" is clearly useless (eg: https://rex.dri.utc.fr/app/university/203/previous-exchanges).
Before button click:
![Screenshot_from_2020-04-04_13-00-36](/uploads/07bf1d46f75d9e5b81da75e518543112/Screensho...In some cases, the "Read more button" is clearly useless (eg: https://rex.dri.utc.fr/app/university/203/previous-exchanges).
Before button click:
![Screenshot_from_2020-04-04_13-00-36](/uploads/07bf1d46f75d9e5b81da75e518543112/Screenshot_from_2020-04-04_13-00-36.png)
After button click:
![Screenshot_from_2020-04-04_13-00-46](/uploads/92c2f70c2f6b2f2d90ebed5e9188bf28/Screenshot_from_2020-04-04_13-00-46.png)
We need a better heuristic on when to hide the button (and show the whole text) and when to do the opposite.PR-P20Estelle VeisemburgerEstelle Veisemburger