How to avoid duplicate data in data table visualization

I have data where I have customer names and devices linked to it. I want to visualize this on a data table.

For this, I have added top hit as aggregation in metrics and have used field as Device. In the bucket, I have added terms as aggragation and have used customer as field. This is giving me proper data on data table but device names are repeating. How can we show unique names only.

Welcome to the community! Instead of using Top Hits, you could add a second bucket. You can split by Terms of customer, then Terms of device per customer. You do need to have a metric, such as count.

1 Like