Multipass on Measured Value

Outer measures in calculations, that are the result of nested measures, require multipass (two or more levels/passes of) calculations to determine their values. The passes are performed from the inside level outwards.

Terms and Definitions

  • measured value - 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 measured values may be based on any logical operators in a filter. For more information, see Measured Values.

  • slicer - A slicer is a dimension that is used to divide the results into groups.

  • filter - A filter restricts the result set to those that meet the filtering criteria. For more information as to how filters affect results, see Measured Values.

  • inner measure - A simple measure that has only one level/pass of calculation.

  • outer measure - A nested measure that requires two or more levels/passes (i.e., "multipass") of calculation.

Multipass Calculation Behavior

For multipass calculations that have a filter on a dimension and measured value calculations with a filter on a dimension, the filter on the dimension is applied for the calculation and, for presentation, the filter on the widget or dashboard is applied.

Examples:

  • AVG (X, SUM (Y))

    • SUM (Y) is the inner measure

    • AVG is the outer measure that is nested, requiring multipass to determine its value

    • X is the slicer dimension

  • (sum(X),ALL(Y)) - In this formula, the ALL filter instructs the Analytical Engine to ignore any widget and dashboard filters when calculating the SUM function.

  • (sum(X),f(Y)) - In this formula, the f filter is applied to rows that contain the value Y to generate the result set, and then SUM(X) is calculated on the rows in the result set.