Formulas take into account specific criteria using measured values, which only perform a calculation when the values meet the set of criteria.
Filter the formula:
Create formula
Add the field (criteria) by which you want to filter the formula. In the example below, this is Machine Name. Right click the field and select Filter
Filter the formula by listed items, text options, rankings, etc.
List Filter - A simple example of Measured Value is the use of a list filter
...
| Info |
|---|
Note: If your widget is filtered using measured values, then the measured value will override any other widget or dashboard filters you have for the same fields. |
Calculating Contributions with ALL Function
The All() function returns the total amount for a dimension, and can be used for various use cases. In the following example, we will use the All function to calculate how much each Plant contributed towards the total Good Production.
...