I am having an index where data is logged with a success/fail flag for a specific item.
I want to get a unique list of items who has fail and never a success. Usually a success is expected after fail from time perspective
Sample input
Date | User | Status |
---|---|---|
Jan 01 | user1 | Fail |
Jan 02 | User1 | Success |
Jan 01 | User2 | Fail |
Jan 02 | User2 | Fail |
Output would be only user2