Bring aggregations to chart level

[hoipippeloi]

Description

Bring aggregations to chart level -> be able to add formulas and calculations to the chart to be able to assign lower level (more granular) data to a chart. This way you dont have to write new queries for every chart on the page. Plus it will be easier to read, explain and understand code. Also; creating breakdowns and analyses on the same data will be easier and more straightforward.

What problem would this solve?

For a lot of the charts on a page you need to write separate queries on the same data. This quickly turns into a lot of code which is harder to read, explain and maintain.

How should it work?

<BarChart
data={my_query}
aggr={sum(if(field='value', myvaluefield))}
x='dimensionfield'
y=aggr
/>