It would be great if we had a more low level access to the aggregation framework. For most charts we currently plot we have to create a view and use it as datasource - which works, but is very ¹cumbersome.

¹for us, the truth is - we don't yet know what good application kpis are. So we basically "experiment" with the data to get some insights. Doing this with views requires us to:

1. think about a metric which could be useful

2. create a view for it

3. add it as a datasource

4. create some plots with it

5. refine 1) and start over again

It would be much more comfortable if we could just type our aggregations(even as freetext) inside the charts interface.

Related to: https://webview.canny.io//p/join-in-data-from-other-collections-lookup