Solved

Trying to get the unique count of a string value in rule

  • 21 April 2021
  • 2 replies
  • 14 views

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?

icon

Best answer by matthew_lind 22 April 2021, 22:43

View original

2 replies

Userlevel 6
Badge +1

@sannithravalkole11 - If you’re Rule building, with an eye to update Scorecard, it sounds like you want to COUNT the number of records which have a specific Request Number.

In a Dataset Task, you could add at least these 2 items to the Show section:

  • The Request Number field
  • COUNT of (any other field that’s always populated)

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.

Userlevel 7
Badge +2

@sannithravalkole11 did you get a chance to view the comments here?

@matthew_lind thanks for your inputs.

Reply