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
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