# Trouble making Bar Graph showing the most common value of a field over a given time
**URL:** https://discuss.elastic.co/t/trouble-making-bar-graph-showing-the-most-common-value-of-a-field-over-a-given-time/62864
**Category:** Kibana
**Created:** [October 12, 2016, 8:13pm UTC](https://discuss.elastic.co/t/trouble-making-bar-graph-showing-the-most-common-value-of-a-field-over-a-given-time/62864 "2016-10-12T20:13:31Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@cb2015](https://discuss.elastic.co/u/cb2015)
#### Post date: [October 12, 2016, 8:13pm UTC](https://discuss.elastic.co/t/trouble-making-bar-graph-showing-the-most-common-value-of-a-field-over-a-given-time/62864/1 "2016-10-12T20:13:32Z")
Hi Everyone,
I am trying to make a bar graph that will show the value of a field(storeinfo) with the highest count, every hour, for the past 24 hours. Basically, I want to to show the most frequent storeinfo in my logs, by hour, with the number of times it appeared on the y-axis, and the actual storeinfo and hour in the x-axis.
I currently have a poor workaround for this. My y-axis is set to count, I split the chart by columns as a date histogram with an hourly interval, and have my x-axis set to be a sub aggregation on the term storeinfo.raw ordered by count, descending, and a size of 1.
The attached picture is the result I get
My biggest issue with this result is that every value of storeinfo that is most frequent for at least one hour appears in every 1 hour chunk.
I think I need to do something like y=max(count(storeinfo.raw) (which I already basically have), and need to be able to control the x-axis labels better.
Any help would be appreciated
---
### Author:  [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)
#### Post date: [October 12, 2016, 11:26pm UTC](https://discuss.elastic.co/t/trouble-making-bar-graph-showing-the-most-common-value-of-a-field-over-a-given-time/62864/2 "2016-10-12T23:26:46Z")
Hey Cody,
Hmm, I wonder if it will help if you do an X-Axis Aggregation (Date Histogram) first, and then a Split Bars Sub-Aggregation (Terms) last?
Here's the kind of result I get:
Can you let me know if this helps at all?
Thanks,
CJ
---
### Author:  [@cb2015](https://discuss.elastic.co/u/cb2015)
#### Post date: [October 13, 2016, 8:31pm UTC](https://discuss.elastic.co/t/trouble-making-bar-graph-showing-the-most-common-value-of-a-field-over-a-given-time/62864/3 "2016-10-13T20:31:06Z")
That worked beautifully!
Thank you so much cjcenizal!
Here's what I got with your help:
---
### Author:  [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)
#### Post date: [October 13, 2016, 9:05pm UTC](https://discuss.elastic.co/t/trouble-making-bar-graph-showing-the-most-common-value-of-a-field-over-a-given-time/62864/4 "2016-10-13T21:05:56Z")
Awesome!! Glad I could help, Cody!
CJ
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:36pm UTC](https://discuss.elastic.co/t/trouble-making-bar-graph-showing-the-most-common-value-of-a-field-over-a-given-time/62864/5 "2017-07-06T13:36:43Z")