# Simple grapth of 2 values

**URL:** <https://discuss.elastic.co/t/simple-grapth-of-2-values/28925>\
**Category:** Kibana\
**Created:** [September 9, 2015, 12:53pm UTC](https://discuss.elastic.co/t/simple-grapth-of-2-values/28925 "2015-09-09T12:53:16Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![11191](https://avatars.discourse-cdn.com/v4/letter/1/9dc877/32.png) [@11191](https://discuss.elastic.co/u/11191)\
**Post date:** [September 9, 2015, 12:53pm UTC](https://discuss.elastic.co/t/simple-grapth-of-2-values/28925/1 "2015-09-09T12:53:16Z")

</div>

Hi everyone. I have this much of information

 ![](https://us1.discourse-cdn.com/elastic/original/2X/4/4800fac0058a5ec984d4fc2677e264e9c8a9f312.jpg)

and I want 2 values (WLNode and JSession) to be displayed on a graph.

I want to see amount of JSession of each WLNode to be more specific.

I really tried to figure it out myself but I couldn't, so I would appreciate any help. Thanx in advance.

---

<div class="post-metadata">

**Author:** ![Pieter\_Agenbag](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pieter_agenbag/32/4562_2.png) [@Pieter\_Agenbag](https://discuss.elastic.co/u/Pieter_Agenbag)\
**Post date:** [September 9, 2015, 1:01pm UTC](https://discuss.elastic.co/t/simple-grapth-of-2-values/28925/2 "2015-09-09T13:01:31Z")

</div>

Go to visualize, add a ?Bar chart? or datatable if you please.

Change the metric from count to sum and select the JSession field for it.  
Then Split the bar/datatable rows on term-\>WL Node.

Hope this makes sense.

---

<div class="post-metadata">

**Author:** ![11191](https://avatars.discourse-cdn.com/v4/letter/1/9dc877/32.png) [@11191](https://discuss.elastic.co/u/11191)\
**Post date:** [September 9, 2015, 2:26pm UTC](https://discuss.elastic.co/t/simple-grapth-of-2-values/28925/3 "2015-09-09T14:26:50Z")

</div>

Thank you very much, I appreciate it. But when I change metric from count to sum Filed list appears but it's empty, only when "Unique count" type of aggregation selected Field list has all my fields.  
Any other ideas?

---

<div class="post-metadata">

**Author:** ![Pieter\_Agenbag](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pieter_agenbag/32/4562_2.png) [@Pieter\_Agenbag](https://discuss.elastic.co/u/Pieter_Agenbag)\
**Post date:** [September 9, 2015, 2:30pm UTC](https://discuss.elastic.co/t/simple-grapth-of-2-values/28925/4 "2015-09-09T14:30:37Z")

</div>

Sum , average and other such aggregations can only be performed on number types. If JSession is not in the field list , then the field is probably mapped as a string.

Check your index mapping.  
Unfortunately (as far as I know) you cant change a field mapping once data is loaded.. you'll have to re-index your data.

---

<div class="post-metadata">

**Author:** ![11191](https://avatars.discourse-cdn.com/v4/letter/1/9dc877/32.png) [@11191](https://discuss.elastic.co/u/11191)\
**Post date:** [September 9, 2015, 2:48pm UTC](https://discuss.elastic.co/t/simple-grapth-of-2-values/28925/5 "2015-09-09T14:48:56Z")

</div>

Yep, you're right, it's string, actually I thought about that, hoped it can conver data on the fly, will look for a way to convert this field to number then will try to do like you advised. Thanx again!

---

<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:** [July 6, 2017, 2:13pm UTC](https://discuss.elastic.co/t/simple-grapth-of-2-values/28925/6 "2017-07-06T14:13:33Z")

</div>


