Skip to main content
jbeaumont
Contributor ⭐️⭐️⭐️
April 22, 2021
New Idea

Horizon Analytics formulas to use aggregated metrics

  • April 22, 2021
  • 1 reply
  • 38 views

One thing we’d like to do is build metrics based on aggregated data using Horizon Analytics (SUM:X / SUM:Y). Example:

 

I know the total amount of Success Plan objectives successfully closed-won (e.g., we achieved them) and divid that by the total number of Success Plan objectives closed in that same period (e.g., closed-won + closed-lost). From looking through Horizon Analytics, I don’t believe we can do that today. 

1 reply

rakesh
Gainsight Employee ⭐️
Lets put your data to work!
May 19, 2021

Hi @jbeaumont 

The formula we have in reporting today are single row formula only. We do have it on our short-meidum term roadmap to add window formula also to accommodate the usecase you are mentioning.