Get Free Trial

Add standard deviation as aggregator

kcl asked on January 2, 2018

Do you have any idea how I could achieve standard deviation as calculated value ?
Thank you

5 answers

kcl January 2, 2018

My problem is that in a individual value calculation, I need to use aggregated values (average and count). Is that possible ? 
I need for each value to calculate (((‘the_value’ – ‘average’))^2)/’n’ with ‘average’ and ‘n’ that are “global” aggregations.

Dmytro Zvazhii Dmytro Zvazhii Flexmonster January 2, 2018

Thank you for your question. For now, the expected result cannot be reached with the available functionality. The standard deviation formula requires having separate individual values for the input when Flexmonster’s formulas use only aggregated values. The best way to achieve the expected behavior is to implement a separate std dev formula in Flexmonster as it is already done in Excel Pivot Table. It is a good feature and we will add your request to our list of improvements. For now, I cannot provide you with the ETA for this feature since the roadmap for the nearest releases is already settled. However, we will notify you when the ETA for this task is clarified.
Please let us know if there is anything else we can help you with.

kcl January 2, 2018

Hello Dmytro,
Thank you for your quick answer.

Raffi SARAFIAN January 10, 2018

I confirm that we have a strong interest in this feature, we can only purchase the full license if this can be implemented, our users are only concerned with statistical features.
Best regards,

Illia Brazhko Flexmonster January 10, 2018

Hi Raffi!
We have replied via email, please check your inbox. Thanks!
Kind regards,
Flexmonster Team

Please login or Register to Submit Answer