How To Apply Filter Inside A Formula In Insights

How to apply filter inside a formula in Insights ?

Filters can be applied inside a formula in Insights by

  1. Display the field by first selecting the field that we want to apply the formula
  2. Then select the field on which filter has to be applied
  3. 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 .