Hi Fikri,
Try this:
Sum(Aggr(
sum({$<latency={"=len(trim(terminal_latency))=0"}, [status]={'*IN*'}, duration = {$(=max(duration))},[device_id]>}[duration]),[device_id]))/3600
You will calculate max duration for each device_id
Regards!
