Analytics SAQL Developer Guide

Overview
Quick Start
Examples
Analyze Your Data Over Time
Calculate How Long Activities Take
Display the Opportunities Closed This Month
Forecast Future Data Points with timeseries
Combine Data from Multiple Data Streams with cogroup
Replace Null Values with coalesce()
Dynamically Display Your Top Five Reps with Windowing
Append Datasets using union
Calculate the Slope of the Regression Line
Show the Top and Bottom Quartile
Calculate Grand Totals and Subtotals with the rollup Modifier and grouping() Function
SAQL Reference
Query Performance
PDF

Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.

Show the Top and Bottom Quartile

Use SAQL to calculate percentiles, like the top and bottom quartile of your data.

Example - Show Top Quartile and Bottom Quartile Deal Size by Country

Suppose that you want to see the top and bottom quartile deal size, by country. You want to see the size of the actual deal, not the interpolated (or 'average') deal size. Use percentile_disc(.25) and percentile_disc(.75).

1q = load "Data";
2q = group q by 'Billing_Country';
3q = foreach q generate 'Billing_Country' as 'Billing_Country', percentile_disc(0.25) within group (order by 'Amount' desc) as '25th Percentile', percentile_disc(0.75) within group (order by 'Amount' desc) as '75th Percentile';
4q = order q by '25th Percentile' asc;

Use a bar chart and select Axis Mode > Single Axis to show the top and bottom quartiles together.

Diagram showing percentile continuous.