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

How to get the SUM of averages rather than total?

Answered
Brendan Fry asked on April 15, 2020

Hi,
Please see the attached image and report.
We need to get the SUM (as in the hover over) shown in Total row rather than the AVG.
Is this possible? If so how?
Thanks
Brendan
 

4 answers

Public
Brendan Fry April 17, 2020

Are there any updates on this? 

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster April 17, 2020

Hello, Brendan,
 
Thank you for contacting us.
 
Our team would like to kindly explain that the total is calculated in the same way other values do.
 
Therefore, the total of the measure “#2” is calculated as total of “ZoneArea” / total of “#1”, not the average of previously calculated values.
 
That behavior can not be changed in the current version of Flexmonster.
 
Please contact us in case other questions occur.
 
Best regards,
Illia

Public
Brendan Fry April 20, 2020

This is like a sum distinct, is that possible?
Thanks
Brendan

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster April 22, 2020

Hello, Brendan,
 
Thank you for your feedback.
 
The described aggregation is not available for CSV/JSON data sources. Even so, it is possible to implement your own realization of the custom data source API, where the needed aggregation can be calculated using your custom logic, including the different calculation of totals.
 
The custom data source API itself is a communication protocol that allows exchanging aggregated data between your data layer and Flexmonster. Detailed information about the protocol can be found in our documentation and in the following blog post.
 
Our team would like to kindly notice that such a way may be quite difficult; however, in perspective, its implementation gives the possibility to work with larger data sets and dynamically operate with the way aggregations work.
 
We hope it helps.
You are welcome to contact us in case additional questions arise.
 
Best regards,
Illia

Please login or Register to Submit Answer