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:
- "Deals Won This Quarter" - filtered on closed date in current quarter
- "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