I think it will be difficult like this. But i have an idea 
You can use Transform (Pivot transform).
You will be able to create new data already aggregated.
Group by on your device, and use top_metric in Aggregations to get the last value
1 Like