Creating Formulas Based on Filters

To create formulas that evaluate specific conditions, you can use the measured value function, which performs a calculation only when the values meet a set of criteria.
The criteria for measured values can be based on any logical operators in a filter.
Measured Value Syntax:
(Measure, Scope 1, Scope 2, ..., Scope N)
Measure: A field measure or formula.
Scope: A filter, including numeric value, text, list, ranking, and time filters.
To create a formula with filters:
  1. Define a formula in the Formula Editor.
    For more information, see Creating and Editing Formulas.
  2. Enter the syntax for the measured value function and include the field that you want to use as a filter in the formula.
  3. Right-click the field and select Filter.
  4. In the Filter dialog box, select a type of filter from the tabs on the left and specify filtering details in the panel on the right.
  5. Click OK.

For example, you can use the measured value function with a list filter to count only 2-sided jobs.Formula Editor - List Filter

Another example is using a ranking filter to track the contribution of best-performing printers to the total number of printed sheets. You can create a formula that calculates the number of printed sheets only for top-ranking printers. This formula filters the data dynamically since the list of top-ranking printers changes over time based on printer performance.Formula Editor - Ranking Filter

Note: If a widget is filtered using measured values, the measured value overrides any other widget or dashboard filters specified for the same fields.