How can we help?
Formulas & Functions
Learn how to perform calculations and manipulate your data using formulas and functions.
Function Reference Guide
Writing Formulas
- Introduction to the formula bar
- How do I use the formula bar?
- The formula bar: Copying and pasting formula elements
- Klips: Writing formulas using results references in the Klip Editor
- Klips: Writing formulas using formula references in the Klip Editor
- Circular references: Why am I getting an error when using references?
Using Functions in the Klip Editor
- DATASOURCE function
- DATE and DATEVALUE
- DATERANGE function
- DATE_IN
- GROUP, GROUPBY, and COUNTDISTINCT (+video)
- Using GROUPBY to create a spark line, spark bar, or win/loss mini chart