derive max (last modified date) for each group of data

[Maddy]

I have a table with columns--id,type,date,date last modified by,date last modified date.

Situation is the date can be changes different times by different people.everytime the date changed it will be a new record  as last modified by and last modified date,type  with same ID .

Question--how can I get the max(last modified date) and max( last modified by ) for each id.with out duplicates ids in the table.

Current view

Id    Type     Market    modified  date          last modified by.(string)       last modified date(string)
1.        A.        Alpha        10/21/2022.               ×                                           3/2/2022
2.        B.        Beta.          3/18/2021.                 Y                                         4/7/2018
1.         A       Alpha           8/16/2020.               Z.                                         3/2/2020

1.       A         Alpha            3/4/2023.                 Y.                                         2/7/2019

2.        B.       Beta.           4/3/2022.                    X.                                       6/6/2017           

Expected view

Id    Type     Market    modified  date          last modified by.             last modified date
1.        A.        Alpha        10/21/2022.               ×                                           3/2/2022
2.        B.        Beta.          3/18/2021.                  Y                                         4/7/2018

How can we achieve this through lookml.Appreciate your help.