Get Free Trial

Calcuate difference on calculated column?

qwalker 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?

3 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster October 1, 2019

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.

Christophe November 28, 2019

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 ?

Vera Didenko Vera Didenko Flexmonster 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:
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, 

Please login or Register to Submit Answer