json - How to avoid duplicate data on kibana dashboard

Question

I have JSON data in elasticsearch where I have multiple customers and their devices. I want to visualize this data in Data Table. For this I have selected aggregation as top hit and field as device in Metrics.

Then I have added a split row bucket where I have added terms as aggregation and selected customers as field. This gives me below table where I have customers and devices under each customers.

But as you can see there are lots of device name getting duplicated because it it picking up the top 100 hits. Is there any way we can only show the unique device names and ignore the duplicated names. Thanks

Answer 1

等待大神答复