SISENSE FORMULA REFERENCE

SISENSE FORMULA REFERENCE

Formulas are custom calculations performed on one or more field in the data. They offer an important way to analyze results and express business logic. This guide provides an overview to working with formulas along with important tips and examples. SiSense formula capability is designed around several principles;

Create complex business calculations without IT or technical knowledge. Easily combine fields from different data sources together. Customize formulas to reflect specific criteria and conditions Work with raw data with no need to summarize data sets before creating formulas. Instantly recalculate formulas based on any filter, variable or level of granularity.

The table below provides a reference to the main formula functions available in SiSense.

GOAL

Perform Calculation based

on Criteria

Combine Data/ Apply Simple Mathematics

Summarize Data

FUNCTION

TYPES AND SYNTAX

Measured Value Aggregate Functions

Value Filters: ,=, >, ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download