# How to use Metric to display a group of values
**URL:** https://discuss.elastic.co/t/how-to-use-metric-to-display-a-group-of-values/89256
**Category:** Kibana
**Created:** [June 13, 2017, 7:20pm UTC](https://discuss.elastic.co/t/how-to-use-metric-to-display-a-group-of-values/89256 "2017-06-13T19:20:01Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@smlbiobot](https://discuss.elastic.co/u/smlbiobot)
#### Post date: [June 13, 2017, 7:20pm UTC](https://discuss.elastic.co/t/how-to-use-metric-to-display-a-group-of-values/89256/1 "2017-06-13T19:20:01Z")
I am trying to use Kibana Visualize to do what I normally do with DataDog’s gauges: showing the last known value of a specific variable.
My data looks like this:
What I would like it the Visualize: Metric to do is:
1. Read all the available names from the role\_name column.
2. Display the value in the role\_count column.
But I can’t figure out how I might do that. I also tried to do it with the Data Table but I don’t know how either. Specifically it seems that these tools are trying to look for occurances of rows matching those values, but I want to show the values in the fields.
I realize that I probably can build all the queries manually but that won’t work if the role\_names are not known beforehand — not to mention that it would be a bit messy.
Any help would be appreciated!
---
### Author:  [@smlbiobot](https://discuss.elastic.co/u/smlbiobot)
#### Post date: [June 13, 2017, 7:25pm UTC](https://discuss.elastic.co/t/how-to-use-metric-to-display-a-group-of-values/89256/2 "2017-06-13T19:25:31Z")
Ok so I managed to get the Data Table to work now:
But I still can’t figure out:
- How to get the Metric to split all rows from the table into its own display.
- How to sort the rows neither alphabetically or by metric. What I in fact need is to sort the rows by the role\_hierarchy\_index seen from my first screenshot above. (number values which show hiearchy in a list)
---
### Author:  [@spalger](https://discuss.elastic.co/u/spalger)
#### Post date: [June 14, 2017, 4:33pm UTC](https://discuss.elastic.co/t/how-to-use-metric-to-display-a-group-of-values/89256/3 "2017-06-14T16:33:56Z")
If you want to split each row into it's own display you might want to use the "metric" visualization type, which renders each bucket as a single number.
I used it below, and setup a custom sorting aggregation for the terms agg based on the `max` of the `role_hierarchy_index` field
---
### Author:  [@smlbiobot](https://discuss.elastic.co/u/smlbiobot)
#### Post date: [June 14, 2017, 4:38pm UTC](https://discuss.elastic.co/t/how-to-use-metric-to-display-a-group-of-values/89256/4 "2017-06-14T16:38:53Z")
@spalger Thanks that’s what I tried to do but I don’t have the option to aggregate Terms in my options.
I see that you have a panel for Buckets, which I don’t have…
---
### Author:  [@spalger](https://discuss.elastic.co/u/spalger)
#### Post date: [June 14, 2017, 4:42pm UTC](https://discuss.elastic.co/t/how-to-use-metric-to-display-a-group-of-values/89256/5 "2017-06-14T16:42:43Z")
Ah, I'm using an unreleased version of Kibana. Looks like that feature when in with [https://github.com/elastic/kibana/pull/10336](https://github.com/elastic/kibana/pull/10336) which will be shipping soon in 5.5
---
### Author:  [@smlbiobot](https://discuss.elastic.co/u/smlbiobot)
#### Post date: [June 14, 2017, 5:45pm UTC](https://discuss.elastic.co/t/how-to-use-metric-to-display-a-group-of-values/89256/6 "2017-06-14T17:45:13Z")
Oh sweet — hopefully soon. This is _exactly_ what I needed. With this new update I can kill datadog completely!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 12, 2017, 5:45pm UTC](https://discuss.elastic.co/t/how-to-use-metric-to-display-a-group-of-values/89256/7 "2017-07-12T17:45:18Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.