New Idea
Rules Engine: Allow stat functions to be grouped
It would be helpful if bionic rules allowed you to use GroupBy when adding a stat formula to the dataset.
Use case:
When calculating something like standard deviation and z-score for a customer's usage, I would like compare their most recent usage to their usage historically– for things like health score and CTAs.
If I can calculate a customer's average usage for the past X number of weeks and standard deviation for the distribution and weekly usage, I can compare the most recent week's usage to their historical average and know how significant the delta is for that customer.
The reason I would want to do this on a per-customer basis as opposed to calculating the stdev across all customers, is that we have (as I would imagine is the same as a lot of Gainsight customers) such a wide-range of usage patterns across customers. And I wouldn't necessarily want to compare, for instance, low-tier customer's usage against the aggregated average and stdev of all customers.
What's helpful to know, is "is a customer's most recent usage, in-line with what they usually do?" and if not, how significant is the change– positive or negative both good to know.
We do calculate stdev and z-score currently for some of our customers of product lines that we've had in Gainsight for a long time, but as we've added new product lines to our instance I thought I had a shorter route to getting this data with the new stat formulas available. Without being able to use GroupBy in conjunction with the stdev formula, there's just a bunch of additional steps needed to get to this.
Use case:
When calculating something like standard deviation and z-score for a customer's usage, I would like compare their most recent usage to their usage historically– for things like health score and CTAs.
If I can calculate a customer's average usage for the past X number of weeks and standard deviation for the distribution and weekly usage, I can compare the most recent week's usage to their historical average and know how significant the delta is for that customer.
The reason I would want to do this on a per-customer basis as opposed to calculating the stdev across all customers, is that we have (as I would imagine is the same as a lot of Gainsight customers) such a wide-range of usage patterns across customers. And I wouldn't necessarily want to compare, for instance, low-tier customer's usage against the aggregated average and stdev of all customers.
What's helpful to know, is "is a customer's most recent usage, in-line with what they usually do?" and if not, how significant is the change– positive or negative both good to know.
We do calculate stdev and z-score currently for some of our customers of product lines that we've had in Gainsight for a long time, but as we've added new product lines to our instance I thought I had a shorter route to getting this data with the new stat formulas available. Without being able to use GroupBy in conjunction with the stdev formula, there's just a bunch of additional steps needed to get to this.