Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How aggregation values are calculated.

Ankush asked on August 16, 2019

We want to understand how in-built aggregation values(screenshot attached) are calculated by flexmonster. What formulas are used etc. Can you provide some documentation around it?

1 answer

Vera Didenko Flexmonster August 16, 2019

Thank you for your question.
In Flexmonster aggregations are calculated like in Excel pivot table:

  1. Sum, Count, Distinct Count, Average, Product, Min, Max, Population StDev, Sample StDev:
  2. % of Grand Total, % of Column, % of Row, Difference, % of Difference, Index:
  3. How Running Totals work is explained in the following blog post:

Please let us know if you have any questions.
Best Regards,

Please login or Register to Submit Answer