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

Newer Version Available

This content describes an older version of this product. View Latest

Dynamically Display Your Top Five Reps with Windowing

Windowing functions perform calculations over a dynamic range.

Example - Dynamically Display Your Top Five Reps

Use windowing to create a chart that dynamically displays your top-five reps for each country. The chart updates continuously as opportunities are won. The example uses windowing to calculate:
  • Percentage contribution that each rep made to the total amount, partitioned by country
  • Ranking of the rep’s contribution, partitioned by country
These calculations let us display the top-five reps in each country.

The resulting graph shows the top-five reps in each country and displays each rep’s ranking.

Diagram showing the meeting dataset.