If you’ve ever wanted a customer record to show their total spend, their most recent order, or a running balance across connected records, Rollup fields handle all of that. Akiva just finished a 6-part video series covering every Rollup function, each one built from a simple example in a data table.
- Rollup basics: Sum, Count, Average, Min, Max and Concatenate, plus conditions
https://youtu.be/TGfmy9aSEWU - Running totals and running averages, including restarting the total per group
https://youtu.be/dxGD5EcQQuI - Rank vs Row Number (and Divide into Groups), and what happens on a tie
https://youtu.be/CqcEYCnerLw - Previous Value and Next Value: compare each row to the one before it
https://youtu.be/iTRuoQ-d7QE - First, Last and Nth Value: a customer’s first purchase, latest status, and more
https://youtu.be/h0NeYWYFo-0 - Standard deviation and variance, explained visually
https://youtu.be/cSzSg5cRjvE
Each video runs 3 to 5 minutes and ends with the rules that tend to trip people up, like why Order By matters and how ties are handled.
Full playlist: https://www.youtube.com/playlist?list=PLOzk085OyqVg
Rollup field docs: Rollup | Fields
Have a Rollup use case you’re stuck on, or a topic you’d like us to cover next? Reply below.