Support for Standard Deviation Function in Dashboard

[vittalkini]

Can we have standard deviation function support in the dashboard ? One of the customer is looking to calculate standard deviation dynamically. Currently the way to achieve this is to calculate it in MV. This will not work as the standard deviation calculation will not change when the user filters the data or groups it based on different grouping dimension

Standard deviation is one of the standard function and would be good to have it supported as a runtime function in dashboard

[mmastropaolo]

In addition to this, a basic statistics package would be great! Percentile functionality would be fantastic.

[IamtheLaw382]

Can we get an update on this?

[dylanwan]

An alternative way to MV is to use the advanced Spark SQL view.  The difference between these two approaches is that MV is executed as part of the data refresh job, the Spark SQL view can be calculated during runtime when the data is loaded to analytics service.