# How do I sync these two values with with a vertical bar chart in kibana? **URL:** \ **Category:** Kibana\ **Created:** [June 14, 2016, 6:40pm UTC](https://discuss.elastic.co/t/how-do-i-sync-these-two-values-with-with-a-vertical-bar-chart-in-kibana/52774 "2016-06-14T18:40:25Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Akashi\_Seih](https://avatars.discourse-cdn.com/v4/letter/a/ba8739/32.png) [@Akashi\_Seih](https://discuss.elastic.co/u/Akashi_Seih)\ **Post date:** [June 14, 2016, 6:40pm UTC](https://discuss.elastic.co/t/how-do-i-sync-these-two-values-with-with-a-vertical-bar-chart-in-kibana/52774/1 "2016-06-14T18:40:25Z")
Hi, I have a JSON file which I have on my Elasticsearch: [http://hostcode.sourceforge.net/view/6074.txt](http://hostcode.sourceforge.net/view/6074.txt) As you can see, it's a HAR file. The two values that I am interested in is URL and "time" (response time). I have tried to set up a vertical bar chart where the Y axis is the response time and the X axis are the URL:s themselves. The problem is that the Y axis only has the options count, average, sum, median, min, max, unique count and percentiles. There is no option to grab the term log.entries.time from my JSON file and have it as an axis. I can however grab my X axis as terms and display my URLS. This is how it looks in my visualization right now: ![](https://us1.discourse-cdn.com/elastic/original/2X/3/303ce0f13083ad94e579f9177afdedbceb3dcb8e.png) I'm really stuck here and I really want to create this bar chart! All the help I can get is **greatly** appreciated. Example of the bar I want to create with kibana: ![](https://us1.discourse-cdn.com/elastic/original/2X/b/b5f64b916fe4ec0d832328d562cc6d6d5ebcdbae.png) ---
**Author:** ![Akashi\_Seih](https://avatars.discourse-cdn.com/v4/letter/a/ba8739/32.png) [@Akashi\_Seih](https://discuss.elastic.co/u/Akashi_Seih)\ **Post date:** [June 15, 2016, 6:15am UTC](https://discuss.elastic.co/t/how-do-i-sync-these-two-values-with-with-a-vertical-bar-chart-in-kibana/52774/2 "2016-06-15T06:15:45Z")
Hi. Can somone please help me? ---
**Author:** ![jbudz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jbudz/32/45922_2.png) [@jbudz](https://discuss.elastic.co/u/jbudz)\ **Post date:** [June 15, 2016, 3:37pm UTC](https://discuss.elastic.co/t/how-do-i-sync-these-two-values-with-with-a-vertical-bar-chart-in-kibana/52774/3 "2016-06-15T15:37:07Z")
If you change the Y-axis aggregation to something like Average, it should give you another select box with the option to select your time field. ![](https://us1.discourse-cdn.com/elastic/original/2X/8/86ae72239227357a5cf92483375345b06edf87cb.png) ---
**Author:** ![Akashi\_Seih](https://avatars.discourse-cdn.com/v4/letter/a/ba8739/32.png) [@Akashi\_Seih](https://discuss.elastic.co/u/Akashi_Seih)\ **Post date:** [June 15, 2016, 5:01pm UTC](https://discuss.elastic.co/t/how-do-i-sync-these-two-values-with-with-a-vertical-bar-chart-in-kibana/52774/4 "2016-06-15T17:01:39Z")
Hi Jon and thank you for the answer, I am aware that I can select my time field with the Y-axis. What I am stuck with is correlating the Y-axis (time) with my X-axis (url). This is what I don't know how to implement. At the moment my bar looks like this. All the URL:s have the same value, and I want to make them different so that they are linked to the .time field. ![](https://us1.discourse-cdn.com/elastic/original/2X/c/c434301f6d3488178cf8616c73ee3ff5fbcdd4d1.png) ---
**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, 1:50pm UTC](https://discuss.elastic.co/t/how-do-i-sync-these-two-values-with-with-a-vertical-bar-chart-in-kibana/52774/5 "2017-07-06T13:50:26Z")