# Showing Max Value Per Unique Host

**URL:** <https://discuss.elastic.co/t/showing-max-value-per-unique-host/367258>\
**Category:** Kibana\
**Created:** [September 27, 2024, 5:38pm UTC](https://discuss.elastic.co/t/showing-max-value-per-unique-host/367258 "2024-09-27T17:38:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![wwalker](https://avatars.discourse-cdn.com/v4/letter/w/43a26b/32.png) [@wwalker](https://discuss.elastic.co/u/wwalker)\
**Post date:** [September 27, 2024, 5:38pm UTC](https://discuss.elastic.co/t/showing-max-value-per-unique-host/367258/1 "2024-09-27T17:38:16Z")

</div>

I have a dataset that records the application version installed on a host. There are multiple records for each host, one for each version of the application that's been installed. Something like

```auto
[
  {
    "hostname": "abc123",
    "version": 12
  },
  {
    "hostname": "abc123",
    "version": 14
  },
  {
    "hostname": "xyz789",
    "version": 12
  },
  {
    "hostname": "lmn456",
    "version": 14
  }
]

```

I'm trying to figure out how I can generate a visual that shows the maximum version of an app per host and only count that host once for each version bucket. So given the above, the visual would look like:

| version | count |
| --- | --- |
| 12 | 1 |
| 14 | 2 |

It doesn't necessarily need to be a table, though that seems to be the most logical way to present the data.