Skip to Content
avatar image
Former Member

Tag/mark/count first occurence of outcome for an episode ID

Hi,

Not sure how to classify the question as new to BOXi

Data

Client ID Episode New/Return Date Desired

123 101 New 17/17 New

123 101 Return 3/7/17 Return

123 101 New 8/7/17 'Duplicate/Mistake'

123 102 New 15/7/17 New

456 201 New 6/7/17 New

456 201 Return 9/7/17 Return

456 201 Return 10/7/17 Return

456 201 New 16/7/17 'Duplicate/Mistake'

There should only be one 'New' per episode so lines 3 and 8 are incorrect. I need to mark the first New within each episode (occurring at the earliest date within an episode) as 'New' and any other instances of a new within an episode as a mistake effectively. (something like the Desired column I've added)

I then want to show:

  • Number of New (as original data)
  • Number of Unique News
  • Number of Duplicate News
  • Number of Repeats (as original data)
  • Number of Actual Repeats (original repeats + duplicate news)

I've tried a number of things and (long story short) am not getting close. Any help appreciated!

Thanks

SAP BusinessObjects BI Platform 4.1 Support Pack 6 Patch 1
Version: 14.1.6.1760

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers