We have imported data into gainsight with Request Number which are strings. one request number can have multiple line items. So the line items are identified with the same Request Number as unique identifier. Now I am trying to build a rule to update scorecard based on the count of Request number. can anyone help me how to count the Same request number records?
Best answer by matthew_lind
View original
+9
In a Dataset Task, you could add at least these 2 items to the Show section:
The Task will then return each a row for each Request Number, and within the row will be a COUNT of the number of records for each Request Number in the dataset.
+1
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.
