locked
Get first and last dates when assigned to team RRS feed

  • Question

  • User-835657614 posted

    Hi 

    Just starting on a report for cases being sent between different teams but am stuck as I can get the desired outcome. For each case I would like to find the first date the case sent to Team 3 and also last time it was re-sent to Team . 

    Using Data below:

    ID

    Date

    Current Team

    Case1

    12/10/2018

    Team_1

    Case1

    13/10/2018

    Team_3

    Case1

    15/10/2018

    Team_2

    Case1

    17/10/2018

    Team_3

    Case1

    20/10/2018

    Team_2

    Case2

    20/10/2018

    Team_1

    Case2

    22/10/2018

    Team_2

    Case2

    25/10/2018

    Team_3

    Case2

    25/10/2018

    Team_2

    and the desired report should look like

    ID

    First time sent to Team_3

    Last time sent to Team_3

    Case1

    13/10/2018

    17/10/2018

    Case2

    25/10/2018

    25/10/2018

    I tried using First, Last but can't get the desired output.

    Thanks in advance

    Jas

     

    Thursday, October 25, 2018 3:24 PM

All replies