How to apply filter inside a formula in Insights ?
Filters can be applied inside a formula in Insights by
- Display the field by first selecting the field that we want to apply the formula
- Then select the field on which filter has to be applied
- Right click on the new field and apply filter.
For example, in the below screenshot, display count[jobkey] and apply filter on job state - Display the count of jobkey where the jobstate is successful / faulted.
Read more on Creating Formulas Based on Criteria and Conditions .