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?
Are there any updates on this?
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.
This is like a sum distinct, is that possible?
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.