L2022.6
- W2022.3.X
- L2022.5
- L2022.6
- L2022.7
- L2022.8

Introduction to Formulas

9 Articles in this category

Print
Share
Dark

Light

Introduction to Formulas

9 Articles in this category

Share
Dark

Light

Creating and Editing a Formula

The Data Browser enables you to use formulas (freeform expressions) to determine the values and filters of a widget. A rich variety of functions is provided for your use in formulas. To create or edit a formula: Open the formula editor in...

Updated on : 18 May 2022

Reusing Formulas

Formulas that you have previously marked as favorites (starred) can be reused. Formulas are saved per ElastiCube. Important: Changing a starred formula does not affect previous uses of that formula. These will continue ...

Updated on : 18 May 2022

Using R in Formulas

R is a software environment for statistical computing and graphics. Sisense supports the integration of R functions in your formulas. You can write R code directly in the formula editor, and send fields as parameters. You can also combine R func...

Updated on : 18 May 2022

Creating Formulas Based on Criteria and Conditions (Filters)

Often formulas must take into account specific criteria. To do this Sisense provides a feature called Measured Value , which like the SUMIF function in Excel, only performs a calculation when the values meet a set of criteria. Criteria for Measu...

Updated on : 18 May 2022

Using Conditional Statements

Conditional statements are formulas that enable you to create additional categories in your data set. When the condition is met, the new category is added to your visualization without modifying the data source itself. For example, if you want to ...

Updated on : 18 May 2022

Building Formulas with Functions

You can use functions to build formulas that aggregate, summarize, and accumulate data, plus show changes in data over time. Combine Data: Aggregate Functions Aggregations are used to perform mathematical calculations on data. This being such an...

Updated on : 18 May 2022

Working with Functions

Sisense provides a large number of built-in functions that you can use to perform specific calculations or return information about your data. You can use the functions on their one or within formulas. The functions are organized into four categori...

Updated on : 18 May 2022

Using Quick Functions

Just like Reusing Formulas , quick functions is another feature to make working with formulas easier. The Widget Designer provides a variety of predefined commonly used functions that you can easily apply in the Data Browser when selecting a Value ...

Updated on : 18 May 2022

Dashboard Function Reference

The following is a list of all the functions you can use in Sisense’s formula editor. Aggregative functions are marked with (A) next to their names, row functions are marked with (R) next to their names. Functions that are only supported for Elasti...

Updated on : 25 May 2022