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.

This list shows the order of evaluation for analyses:

  1. Level-aware calculation - window (LAC-W) Prefilter level: Evaluates the data at the original table cardinality before analysis filters.
    1. Simple calculations: Calculations at scalar level without any aggregations or window calculations are applied. For example, date_metric/60, parseDate(date, 'yyyy/MM/dd'), ifelse(metric > 0, metric, 0), split(string_column, '|' 0).
    2. LAC-W function PRE_FILTER: If any LAC-W PRE_FILTER expression is used in the visual, RICOH Supervisor first computes the window function at the original table level, before any filters. If the LAC-W PRE_FILTER expression is used in filters, it is applied at this point. For example, maxOver({Printed Pages}, [{Location Name}, {Printer Name}], PRE_FILTER) > 1000.
  2. LAC-W Preaggregate level: Evaluates the data at the original table cardinality before aggregations.
    1. Filters added during analysis: Filters created for unaggregated fields in the visuals are applied at this point, similar to WHERE clauses. For example, year > 2020.
    2. LAC-W function PRE_AGG: If any LAC-W PRE_AGG expression is used in the visual, RICOH Supervisor computes the window function before any aggregation applied. If the LAC-W PRE_AGG expression is used in filters, it is applied at this point. For example, maxOver({Printed Pages}, [{Location Name}, {Printer Name}], PRE_AGG) > 1000.
    3. Top/bottom N filters: Filters that are configured on dimensions to display top/bottom N items are applied.
  3. Level-aware calculation - aggregate (LAC-A) level: Evaluates aggregations at a customized level, before visual aggregations.
    1. Custom-level aggregations: If any LAC-A expression is used in the visual, it is calculated at this point. RICOH Supervisor computes the aggregation, grouped by the dimensions that are specified in the calculated fields. For example, max({Printed Pages}, [{Location Name}]).
  4. Visual level: Evaluates aggregations at visual level and post-aggregation table calculations, with the remaining configurations applied in the visuals.
    1. Visual-level aggregations: Aggregations based on the fields in the field wells are calculated, grouped by the dimensions from the visuals. If any filter is built on top of the aggregations, it is applied at this point, similar to HAVING clauses. For example, min({Printed Pages}) > 1000.
    2. Table calculations: If there is any post-aggregation table calculation used in the visual, it is calculated at this point. RICOH Supervisor performs window calculations after visual aggregations. Similarly, filters built on post-aggregation table calculations are applied.
    3. Other category calculations: Calculations for the Other category in line charts, bar charts, combo charts, funnel charts, tree maps, pie charts, or donut charts are applied.
    4. Totals and subtotals: Totals and subtotals are calculated in donut charts, tables, or pivot tables.

Parent topic: Using Formulas