[j_l_schwirtz Contributions: 0Level 1☆]

I need a way to select the second call to the customer (this is our follow up call) I know there has to be a way to use rank – I just have never ued it – basically I want to create a search that for each lead looks at the call record for the second call (when ordered by internal id) and returns the call duration.

Thanks in advance

Jodie Schwirtz
This is a cached copy. Click here to see the original post.

[cdelacruz Contributions: 0Level 1☆]

Hello,

Due to Oracle limitation, it’s not possible to use Rank/Dense Rank as Criteria or field under Results tab (when used with Summary Type). As Alternate Solution, you may try the search below:

1. Navigate to Lists > Search > Saved Searches > New.

2. Select Customer.

3. Set your Criteria.

4. Under the Results tab, add: Formula (Numeric).

5. Under Formula Column, use: DECODE((DENSE_RANK() OVER (PARTITION BY {entityid} ORDER BY {call.internalid} DESC)),2,1) .

6. Set Sort By to Formula (Numeric).

7. Under Highlighting tab > Highlight If subtab, set Condition:Filter: Formula (Numeric)
Formula: DECODE((DENSE_RANK() OVER (PARTITION BY {entityid} ORDER BY {call.internalid} DESC)),2,1)
Formula (Numeric) = is
Value = 1

8. Select a Background Color.

9. Click Preview or Save & Run.

Another Alternate Solution is provided in SuiteAnswers Article: Use RANK or DENSE_RANK as Criteria in a Saved Search | Answer ID: 31414 [https://netsuite.custhelp.com/app/an…il/a_id/31414]

[j_l_schwirtz Contributions: 0Level 1☆]

Thanks cdelacruz . I had read the Suiteanswers article – unfortunately since I needed to do statistical analysis I had to export the search to Excel to finish processing my results.

[Author]

Posts