Do you have any idea how I could achieve standard deviation as calculated value ?
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.
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.
Thank you for your quick answer.
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.
We have replied via email, please check your inbox. Thanks!