Hi, I am currently working on a ticket reporting.
Each ticket has a lastUpdateDate field which gets updates multiple times leading to duplicates. I only need the first lastUpdateDate and latest lastUpdateDate to determine when the ticket has entered the pipe and the latest to see if changes were made in the specific period range of the reporting.
I tried using | stats first(_raw) as first_entry last(_raw) as last_entry by ticket_id but it shows me the same lastUpdateDate for both.
I have read to use min and max but do not gain results from that either.
Thanks in advance for any hints and tips!
You have to use latest and earliest to get the oldest and most recent event.