# New to Kibana, not sure how to create a horizontal bar chart

**URL:** https://discuss.elastic.co/t/new-to-kibana-not-sure-how-to-create-a-horizontal-bar-chart/108443
**Category:** Kibana
**Created:** [November 20, 2017, 6:32pm UTC](https://discuss.elastic.co/t/new-to-kibana-not-sure-how-to-create-a-horizontal-bar-chart/108443 "2017-11-20T18:32:42Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![lostsoul352](https://avatars.discourse-cdn.com/v4/letter/l/d2c977/32.png) [@lostsoul352](https://discuss.elastic.co/u/lostsoul352)
#### Post date: [November 20, 2017, 6:32pm UTC](https://discuss.elastic.co/t/new-to-kibana-not-sure-how-to-create-a-horizontal-bar-chart/108443/1 "2017-11-20T18:32:42Z")

</div>

I'm just getting started with Kibana,

I'm analysing log files, and in any given log entry there are 2 pieces of information I'm interested in. One is called a "query name" and the other is "execute time". I've already setup logstash to parse the lines and the fields are mapped correctly.

What I'm trying to do is create a horizontal bar chart with "execute time" on the X-axis and "query name" on the Y-axis, but all that seems to be possible to to have a count of the frequency of each query name.

Is it possible to have 2 different fields in my bar chart?

---

<div class="post-metadata">

### Author: ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)
#### Post date: [November 20, 2017, 7:42pm UTC](https://discuss.elastic.co/t/new-to-kibana-not-sure-how-to-create-a-horizontal-bar-chart/108443/2 "2017-11-20T19:42:39Z")

</div>

hmm, probably you can do this - on the x-axis you need to do a terms aggregation on the query name field and on the y-axis they need to select a metric for the execution time field  
or if you want to display the value from the most recent document with that query name instead of computing an aggregation, you could use the top hit metric . Hope this helps...

Thanks  
Rashmi

---

<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: [December 18, 2017, 7:42pm UTC](https://discuss.elastic.co/t/new-to-kibana-not-sure-how-to-create-a-horizontal-bar-chart/108443/3 "2017-12-18T19:42:47Z")

</div>

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