SIGMA IS ON THE 2025 Gartner® Magic Quadrant™
GET THE REPORT
Part one of this series provides a general overview of writing functions in the formula bar and creating table groupings. Groupings and functions are essential for structuring, calculating, and displaying your data. With groupings, you can calculate aggregates across multiple rows. For example, you can group your data by quarter and then calculate total revenue for each quarter, cluster rows by store region to compare sales by region, track completed tasks by employee name, and much more.
—
Part two of this video series introduces aggregate functions and writing formulas that work across a table grouping. Aggregate functions output a single value based on multiple rows of input, which makes them essential for creating calculations with groupings. They include familiar and easy-to-use functions such as Sum(), Count(), and Avg(), but also many other functions that differ in complexity and possible use cases.
—
Part three of this series covers the basics of how to use window functions in Sigma. Window functions perform calculations based on a specified set of rows in a column. This means you can use them to perform a calculation on only the first row in a column, calculate an average over a moving three month period, determine cumulative revenue, and much more.
—
Part four of this series dives deeper into window functions and the different subcategories they fall into. Window functions are divided into four categories that relate to how they function and interact with your data. Cumulative, moving, shifting, and ranking window functions each have a different purpose and produce a unique result, but are all similar in the way they work only on specified rows rather than entire columns. Some of Sigma’s most commonly used functions, such as the CumulativeSum() and RowNumber() functions featured in this video, are actually window functions.
—
Part five of this series concludes the overview of window functions and covers some general concepts and fundamentals to keep in mind when using the other types of functions available in Sigma. The core fundamentals covered here apply to almost all of Sigma’s other function types, which includes array, date, financial, geography, logical, math, passthrough, system, text, and type functions. There are also several functions that combine multiple operations or calculations into one function, such as the PercentOfTotal() function and the SumIf() function, which this video covers.
—
