No Status

Comparing a Metric for One Time Frame to a Previous Timeframe

  • 31 March 2016
  • 3 replies
  • 18 views

Userlevel 7
Badge
  • Gainsight Employee: MVP
  • 291 replies
We have a few metrics we track over time. For example, how many logins did they have this month versus last month.

In a rule, I can create a comparison for the last 4 weeks compared to the last 8 weeks, but I haven't been able to figure out how to say the last 4 weeks compared to the 4 weeks prior. I'd prefer not to have to write this to another field to do the comparison. 

I would ideally want to show customers who's logins have dropped between last month and this month by a percentage. Or if they have grown what that percentage is.

Is there a way to do this now? Or would this need to be built?

3 replies

Userlevel 6
Yes, this is possible. Here is documentation https://support.gainsight.com/hc/en-us/articles/204520238-Using-Calculated-Fields-in-Rules

When you define the comparison in the Rule you need to select "Prior" for the time frame in second value (as in "Prior 4 weeks") instead of "Past" (as in "Past 8 weeks").
Userlevel 7
Badge
Thanks Karl! That was an oversight on my part. I miss the dropdowns sometimes when I'm trying to figure something out.
Userlevel 6
Great!  Glad it is working now. 

Reply