Skip to Content

Web Inteligence Exception Reporting

Jul 18, 2017 at 03:05 PM


avatar image
Former Member


Not sure how to classify the question as new to BOXi


Client ID Episode New/Return Date Desired

123 101 New 1/7/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!


SAP BusinessObjects BI Platform 4.1 Support Pack 6 Patch 1

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

0 Answers