Using filter logic in metrics
  • 24 Mar 2025
  • 1 minute read
  • Contributors
  • Dark
    Light
  • PDF

Using filter logic in metrics

  • Dark
    Light
  • PDF

Article summary

Silhouette of a person standing, representing human figures in various contexts.RevOps, Business admin

Diamond.png Gong Forecast*

Filtering your base objects (deals or accounts) is rarely as straightforward as saying “Pull all the deals" More often, it requires a more detailed and investigative approach, involving combinations of criteria. For example, "Pull all the deals AND ensure their status is closed-won" or "Pull open deals OR closed-lost deals”. This is where the use of conjunctions becomes handy.

Using conjunctions

Effectively filtering your objects to generate meaningful data points often requires multiple conditions, connected with logical conjunctions - And for when you need all conditions to be met, and Or for when you want to meet any condition.

In the following example, two conditions are connected using the And conjunction. The whole phrase reads as: "Pull deals that were not closed-lost/closed-won AND their type is New Business/Upsell”.

Using condition groups

To build more complex filters, combine single conditions nested within condition groups.

For example, a rule that says “Pull deals that are not closed AND their amount is greater than 30K OR deals that are closed AND their amount is less than 15K”:


Visit our Academy and find out how to utilize your dashboards to boost efficiencies and refine revenue operations

*The features available to you depend on your company’s plan and your assigned seats.


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.
ESC

AI, a genAI helper, will scrub our help center to give you an answer that summarizes our content. Ask a question in plain language and let me do the rest.