Hello Team,
We’ve got a reqeust from a customer, to get the median of the 3 values by relationship id under the transformation task, in the Data Designer.
After checking on this intenraly, it seems this hasn’t been implemented yet and there is no workaround as well.
Can you please consider the above use case and implement it in furture?
Thank you.
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Thank you for posting this Isaac.
Just to expand on the use case a little more, I would like to be able to get the median of 3 values by relationship id, for many relationship id’s.
In the transform task currently, the median is being calculated for all lines, but instead I need it to be calculated based on 3 values per relationship id.
For example, in the table below, there are 3 values per relationship id. As things are now, the median is calculated for all 6 entries, but instead I need to be able to calculate the median for the 3 values for customer 1, and separately for the 3 values for customer 2.
Hi@pamela_mackie
Thanks for bringing this up.
I think row grouping in the new reporting is a good way to solve this. Let me get back to see if we can solve this.
Thank you Rakesh,
The median of the 3 values would needed for use in a rule.
My hope was to be able to use the rules engine, or data designer to get the median, and then use that value in a rule.