MEDIAN(): MEDIAN([Sales]) : Median value

STDEV(): STDEV([Sales]) : Sample standard deviation

VAR(): VAR([Sales]) : Sample variance

CORR(): CORR([Sales],[Profit]) : Correlation coefficient

COVAR(): COVAR([Sales],[Profit]) : Covariance

TRENDLINE: Add Trend Line (Linear) : Visualize regression trend

FORECAST: Enable Forecast : Automatic exponential smoothing projection

REFERENCE LINE: Add average reference line : Show benchmark across axis

CLUSTER: Analytics > Cluster : Automated k means segmentation

BOX PLOT: Show Box Plot : Five number summary

PERCENTILE( ): PERCENTILE([Sales],0.95) : 95th percentile row-level

QUANTILE( ) : QUANTILE([Sales],0.25) : Quartile value

Z-SCORE: (SUM([Sales])-WINDOW_AVG(SUM([Sales])))/WINDOW_STDEV(SUM([Sales])) : Standardize metric

BIN(): BIN([Age],5) : Bucket continuous into bins

Histogram: Show Me > Histogram : Distribution view
Previous Next