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
[
{
"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.