We lack the possibility to define different aggregation rules and levels for different items of the same entity.
For example:
- We have an entity "KPI"
- We have some Ratios in our KPIs
- Ratios need to be calculated at the granularity level that is currently displayed on the Flexgrid
- In Flexgrid, calculations are being performed at the granularity defined by the Dataset
- Unless we are on the lowest level of granularity, Rules will sum up values instead of calculating them
- Using rules messes up with the Flexgrid by multiplying the number of rows and producing overly-heavy reports with huge loading times
There should be a KPI area where the user has the possibility to define how each item is to be calculated: At the lowest level? At the one displayed? Aggregated summing values? Aggregated using averages? Aggregated Taking the First/Last Value?
