How to get the earliest record of the same transaction

[labo2002]

Hello all,

Need your expertise and advise. I have a table that shows the below transactions. We wanted to calculate the number of recordID and their queue time. But for a duplicate record (possibly transferred transaction), we wanted to get the earliest record only. 

RecordID	DateTime	Agent	Queue
AA	14/02/2020 17:00	Agent1	00:00:05
AA	14/02/2020 18:00	Agent2	00:01:25
AB	14/02/2020 17:00	Agent3	00:00:10

I tried count distinct RecordID, but with the other Dimensions not the same, it still counted as 2 record.

Appreciate your help on this. 

[tresesco]

Are you trying to get the output in a chart? If so, you could probably use TOTAL identifier to ignore dimension in count().