Data aggregation

[AFoletti]

Is your feature request related to a problem? Please describe. Sometimes you have data that looks very complicated and messy in a Visualize chart, but that could be made much easier and more readable with a simple aggregation. See this plot as an example. There are 26 lines for the 26 cantons. So much that, in fact: a) many cantons are indistinguishable one from another, because it's impossible to have 26 color-coded classes that are readable b) it is difficult to identify a trend

Describe the solution you'd like Sometimes it makes sense to aggregate the data along one of the available keys. It would be nice to have an option to set one of the available filters to act as an aggregator and have the plot show the summed-up results. In the example above I could aggregate per year and have a result similar to that, with a single line showing the sum across all cantons.

Describe alternatives you've considered This can of course be solved at the data level, but it is in my opinion inelegant and requires quite a deep modification of the data model. In my opinion, the data should not adapt to the tool.

Additional context I am not sure, but I maybe overheard someone saying that this kind of operation is explicitly out of Visualize's scope? If it is, feel free to close this FR.

EDIT: Fixed link to chart

[ptbrowne]

This is something that I believe we'll work on in the future, particularly with respect to the hierarchies and the drill-down/up features. Dimensions would be annotated with how can they be aggregated (sum, mean etc...) with respect to another dimension.