# How to pick the value of the integer

**URL:** <https://discuss.elastic.co/t/how-to-pick-the-value-of-the-integer/120081>\
**Category:** Kibana\
**Created:** [February 15, 2018, 10:05pm UTC](https://discuss.elastic.co/t/how-to-pick-the-value-of-the-integer/120081 "2018-02-15T22:05:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pororo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pororo/32/27711_2.png) [@Pororo](https://discuss.elastic.co/u/Pororo)\
**Post date:** [February 15, 2018, 10:05pm UTC](https://discuss.elastic.co/t/how-to-pick-the-value-of-the-integer/120081/1 "2018-02-15T22:05:21Z")

</div>

Hi, I just wanted to make a simple graph that the x-axis is supposed to be the name of the student and the y-axis is the age of the student.

But I am kinda confused about how to set the metrics.

 ![39](https://us1.discourse-cdn.com/elastic/original/3X/9/6/964a3f1ba47f4b2bac3c086943556d169a2ebd28.png)

This is almost what it will be like but for the y-axis, I chose the avg to make this graph.  
So how do I just pick the value of the age for the y-axis. It seems there are only options for aggregation.

---

<div class="post-metadata">

**Author:** ![Pororo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pororo/32/27711_2.png) [@Pororo](https://discuss.elastic.co/u/Pororo)\
**Post date:** [February 15, 2018, 10:06pm UTC](https://discuss.elastic.co/t/how-to-pick-the-value-of-the-integer/120081/2 "2018-02-15T22:06:15Z")

</div>

my data format is  
{"name" : "Alice", "age" : 17}

---

<div class="post-metadata">

**Author:** ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)\
**Post date:** [February 15, 2018, 10:51pm UTC](https://discuss.elastic.co/t/how-to-pick-the-value-of-the-integer/120081/3 "2018-02-15T22:51:29Z")

</div>

The visualization builder does not know that your terms aggregation is yielding buckets with one document each in it. So, that is why you are being asked to choose an aggregation and not a value.

---

<div class="post-metadata">

**Author:** ![Pororo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pororo/32/27711_2.png) [@Pororo](https://discuss.elastic.co/u/Pororo)\
**Post date:** [February 17, 2018, 10:30pm UTC](https://discuss.elastic.co/t/how-to-pick-the-value-of-the-integer/120081/4 "2018-02-17T22:30:45Z")

</div>

So how could I achieve the effect I wanted as above by using visulization builder

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 17, 2018, 10:31pm UTC](https://discuss.elastic.co/t/how-to-pick-the-value-of-the-integer/120081/5 "2018-03-17T22:31:05Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.