Using Formulas

Formulas are custom calculations performed on one or more data fields. You can use formulas to create calculated fields that transform your data by combining operators, functions, data fields from your data sources, or other calculated fields. The calculated fields that you add to a dataset in an analysis are available only in that analysis.
Note: This function is only available with the Self-Service feature. If you want to purchase this feature, contact your Ricoh representative.

You can see information on all the available functions directly in the Add calculated field dialog when you click a function in the list.

In this section:

  1. Adding Calculated Fields to Analyses
    You can create calculated fields that transform your data with mathematical operations and different types of functions. The calculated fields that you add to a dataset in an analysis are available only in that analysis.
  2. Supported Operators and Functions
    When you create calculated fields for your analyses, you can use a variety of operators and functions.
  3. Order of Evaluation in Analyses
    When you open or update an analysis, RICOH Supervisor evaluates everything that is configured in the analysis in a specific order. The order of evaluation helps you understand the sequence that dictates when a specific filter or calculation is applied to your data.
  4. Level-Aware Calculations
    With level-aware calculations (LAC), you can specify the level of granularity for computing window functions or aggregate functions. There are two types of LAC functions: level-aware calculation - aggregate (LAC-A) functions and level-aware calculation - window (LAC-W) functions.
Parent topic: Working with Dashboards [New]