Hi all,
I have a data file showing user interactions with our service and each time the user comes in we record what their key issue is. I am trying to find the best way to find the earliest entry for each user and then show the issue that was listed against this entry. I have tried using the MIN function in the field settings of a pivot table but it seems to show the MIN date for each time the 'issue' changes. The data looks like this below. Where the issue is listed as UNSPECIFIED I'd like to skip to the next data for that User that has an entry other than Unspecified. Hope that makes sense. Thanks.
Name Date Issue
Karen 44146 Other
Stewart 44146 Employment
Shirley 44146 Unspecified
Karen 44145 Other
Ian 44145 Other
Colleen 44145 Other
Caroline 44144 Disability Support
Chloe 44145 Other
Erica 44145 Other
Cindy 44145 Other
Kristy 44145 Unspecified
Casey 44145 Other
Brian 44145 Daily Living
Bob 44145 Service Information/Navigation
Melisa 44145 Unspecified
Lesley 44141 Employment
Stewart Unspecified
Joseline 44139 Housing/Tenancy/Homelessness
Lesley 44140 Unspecified
Colleen 44140 Daily Living
Karen 44140 Unspecified
Karen 44139 Mental Health
Shirley 44139 Employment
Susan 44020 Family Functioning
Stewart 44138 Employment
Bookmarks