I was trying to build an simple application where i'm trying to build a simple application where I want to aggregate the dimension on a Max TimeStamp
| Ticket_Name_Total | Description_Total | Ticket_CB_Total | Defect_Number_Total | LD_Name_Total | BS_Name_Total | TimeStamp_Total |
| My First Ticket | Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing. | CB-0001 | DEF-0003 | John Doe | Jane Doe | 4/23/2020 10:05:12 PM |
| My Second Ticket | Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing. | CB-0002 | DEF-0004 | John Doe | Jane Doe | 4/23/2020 9:59:56 PM |
| My Second Ticket | Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing. | CB-0002 | DEF-0003 | John Doe | Jane Doe | 4/23/2020 9:59:44 PM |
| My Second Ticket | Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing. | CB-0002 | DEF-0002 | John Doe | Jane Doe | 4/23/2020 9:59:33 PM |
| My Second Ticket | Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing. | CB-0002 | DEF-0001 | John Doe | Jane Doe | 4/23/2020 9:59:21 PM |
| My First Ticket | Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing. | CB-0001 | DEF-0002 | John Doe | Jane Doe | 4/23/2020 9:59:00 PM |
| My First Ticket | Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing. | CB-0001 | DEF-0001 | John Doe | Jane Doe | 4/23/2020 9:58:41 PM |
| My Second Ticket | Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing. | CB-0002 | | John Doe | Jane Doe | 4/23/2020 9:57:56 PM |
| My First Ticket | Lorem ipsum dolor sit amet consectetur adipiscing, Lorem ipsum dolor sit amet consectetur adipiscing. | CB-0001 | | John Doe | Jane Doe | 4/23/2020 9:56:33 PM |
As result I'm looking for an aggregation that show the latest dimension based on the timestamps and unique Ticket_CB and place this in calculated text field.
Hopefully someone can help me
