Excluding Data Based on Criteria Within Grouping

[carimoffitt]

Hi everyone! I have a a full data list, but I've grouped the list by user accounts and distinct assignment dates. Within this grouping, I want to filter OUT the users who only have dates after January 1, 2019. All of these users have at least one date after Jan. 1, 2019, but I want to include the users that also have assignment dates before 2019. I've attached a sample data set where each "user" is a distinct letter in the alphabet and I've grouped by user and date. In this example, I would want my output to only include "users" D, E, G and L. All of the other users only have assigned dates after Jan. 1, 2019 and I want the user as a whole to be excluded. Anyone have suggestions on how to go about this? Thanks in advance!

[fmvizcaino · Accepted solution]

Hi @carimoffitt ,

I'm attaching a solution where I'm identifying users by summarizing the lowest date value from all of them.

Best,

Fernando Vizcaino

[carimoffitt]

@fmvizcaino  This worked like a charm, thank you so much!