Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Calcuate difference on calculated column?

Answered
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

Public
Dmytro Zvazhii Flexmonster 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

Public
Christophe 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 ?
 
 

Public
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: 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

Please login or Register to Submit Answer