Skip to main content
lane_h
Helper ⭐️
March 31, 2016

Comparing a Metric for One Time Frame to a Previous Timeframe

  • March 31, 2016
  • 3 replies
  • 63 views
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
    Expert ⭐️
    April 1, 2016
    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
    lane_hAuthor
    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.
    Director of CX and Scale Programs
    karl_rumelhart
    Expert ⭐️
    April 1, 2016
    Great!  Glad it is working now.