Skip to main content

    Idea Pipeline

    Filter by idea status

    Filter by product area

    6166 Ideas

    pele
    peleHelper ⭐️⭐️⭐️

    Rules Engine: Allow stat functions to be groupedNew Idea

    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.