Formulas and Functions

Last updated: June 11, 2026

Formulas and functions are powerful tools in Sisense that allow you to transform raw data into meaningful metrics, calculations, and analytical insights. Whether you’re building KPIs, customizing widget behavior, or defining complex analytical logic, formulas give you the flexibility to shape your data exactly the way you need.

Sisense offers a rich formula editor, a comprehensive library of built-in functions, and support for advanced capabilities such as conditional logic, multipass aggregation, and even R-based expressions. You can create formulas directly within widgets, reuse them across dashboards, or define shared formulas for consistent logic throughout your analytics environment.

This section introduces the full ecosystem of Sisense calculation features, including how to:

• Create and edit formulas within widgets

• Build reusable and shared formulas for consistent analytics

• Apply conditional statements and criteria-based logic

• Work with measured values and multipass aggregation

• Use R for advanced statistical or custom computations

• Explore the complete library of functions and quick functions available in Sisense

Use these topics to learn how formulas and functions can enhance your dashboards, enrich your data analysis, and unlock deeper insights across your Sisense environment.