asked on September 29, 2019
Right now it's not possible to apply aggregations(sum, min, max, difference) on calculated columns. Is there any reason why it's not provided? Can Flexmonster take this as a new feature request?
⋅ October 1, 2019
Hello,
Thank you for posting your question here.
Yes, you are right. It is not possible to use aggregations over calculated columns.
We have added your request to the customer's wish list. For now, we are not able to provide you with the exact ETA for this feature since our roadmap is already settled.
Our team will keep you updated on this case.
Regards,
Dmytro
⋅ November 28, 2019
Hello,
I am also interrested by this feature.
Also, I would like to know if it would be possible to have a difference and %difference working on the 2 axes ?
If I am correct, for now, it's only possible to use the difference and %difference on vertical axe. We are using the horizontal axe for the time series (date, months, etc...) and we would like to be able to compare progression of sales on over differents years for example. Do you think this is something that could be added in the near future ?
⋅ November 29, 2019
Hello, Christophe,
Thank you for sharing this with us. We have added you to the list of people interested in the feature.
Regarding using the difference and %difference aggregations on the horizontal axe, we are glad to confirm that this is possible.
To do this, simply specify "[Measures]" in the columns section instead of rows.
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/dsbq0xzL/
In the example, the getReport() API call is used to get the current report object and the runQuery() API call is used to set the modified slice.
Please write to us in case further questions arise.
Best Regards,
Vera
