Issues utilizing Top Hit aggregation

Hello!

I am looking to visualise a table containing info regarding logon locations of devices by recognizing IP patterns. The important bit I'm missing now is getting the table to only show the most recent entry for each unique hostname. I have had a read of similar topics but most if not all of them lead to using the Top Hit metric aggregation on host.hostname and sorting on timestamp, this however in my case results in just adding a column called "Last host.hostname" which shows the exact same data as host.hostname. I'd imagine this is caused by me using multiple Split rows buckets in addition to the Top Hit aggregation. Is there any way to do this on Kibana? Perhaps a DSL query filter on the table?

Would very much appreciate any help
Thanks!