It’s my fault I didn’t develop too much on the proposal.
Take the following example: You have a query that returns 3 Columns:
Revenue. Each city has an entry per Month, which means that January will have as much entries as the number of cities.
Now, if you plot a Chart with bars with X values with the Month and Y Values with the Revenue, I should expect the option to SUM or AVG the values that appear on each Month. Instead, it looks as Redash is just picking up the first one or in some cases plotting an unpredictable Bar height and a non-corresponding legend.
The only workaround this is to do the calculation at the Query level, but now I need to do a Query for each Chart. If this was possible, I could instead run 1x Query for several visualizations.
I hope I explained it clear enough.