asked on January 2, 2018
Hello,
Do you have any idea how I could achieve standard deviation as calculated value ?
Thank you
⋅ 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.
⋅ January 2, 2018
Hello,
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.
Regards,
Dmytro.
⋅ January 2, 2018
Hello Dmytro,
Thank you for your quick answer.
⋅ January 10, 2018
Hello,
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,
⋅ January 10, 2018
Hi Raffi!
We have replied via email, please check your inbox. Thanks!
Kind regards,
Illia
Flexmonster Team
