Rello
Preview and data picker for external datasources
current manual input to be replaced with a column-picker-popup
- [ ] modal popup when selecting the column
- [ ] linking picker to a new option-type in datasource options
- [ ] get available columns incl delimiter via JS or from PHP backend?
Partly understanding your data concept may be the idea could be to separate completely dataload and graphics.
Datasets could be still be 3 culumns data, but when loading a csv file with multiple columns, the logic would be to specify the 2 first colums (Curve, date) then for each extra column an association (dataset (or dataset name)<=> column).
As files like https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/owid-covid-data.csv are long to process, it will enable to analyse the data only once (It's the "heavy part") then use it multiple times in graphics / representations...
Hello,
I think I know what you mean.
you want to report on different key figures/columns.
you could split it in different reports - one per keyfigure. but this is not usable I guess.
What you would need is another column (I am working on a concept here) which defines the keyfigure/filter.
so a curve, date, keyfigure, value
this would work if you would utilize the dataload and load them all into the database. A realtime on multiple datasources (with the current concept, every column-combination would be 1 datasource) is not possible yet.
...but there is more to come. the roadmap is full :-)