cancel
Showing results for 
Search instead for 
Did you mean: 
vittalkini
Partner
Partner
Status: New

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

3 Comments
mmastropaolo
Cosmonaut

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

IamtheLaw382
Astronaut

Can we get an update on this?

dylanwan
Employee
Employee

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.