Skip to main content

Comparing a Metric for One Time Frame to a Previous Timeframe

  • March 31, 2016
  • 3 replies
  • 28 views

lane_h
Forum|alt.badge.img+5
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

karl_rumelhart
Forum|alt.badge.img+4
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").

lane_h
Forum|alt.badge.img+5
  • Author
  • Helper ⭐️
  • April 1, 2016
Thanks Karl! That was an oversight on my part. I miss the dropdowns sometimes when I'm trying to figure something out.

karl_rumelhart
Forum|alt.badge.img+4
Great!  Glad it is working now.