Skip to Content
0

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

Aug 14, 2017 at 06:36 AM

15

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers