Skip to main content

Hi, I’m trying to add a metric that i can use on a dashboard that show much how (what 😵 of total won deals were also created in quarter. 

 

Is there a why to add a period filter onto the metric builder? 

Is there a different way to get the numerator filtered on once date criteria, and the demonitor being on different date period. 

Hey ​@Brett Gibson! I’m looking into this for you. Stay tuned, thanks for your patience!


Hi ​@Brett Gibson !


Short answer:
No
, you can't set different date period filters for the numerator and denominator within a single Gong metric using the metric builder. Both parts of a formula metric inherit the same date filters applied at the widget/dashboard level.
 

Workaround:

Create two separate basic metrics first:

  1. "Deals Won This Quarter" - filtered on closed date in current quarter
  2. "Deals Won & Created This Quarter" - filtered on both closed date AND created date in current quarter

Then build a formula metric dividing #2 by #1.

Pulling from the API is another (& likely more efficient option), let me know if you need help with this.
 

-Peter
 

Ref: Building your own metrics - Gong


Reply