# Grab data from the highest count last week

**URL:** <https://discuss.elastic.co/t/grab-data-from-the-highest-count-last-week/94805>\
**Category:** Kibana\
**Created:** [July 27, 2017, 1:46pm UTC](https://discuss.elastic.co/t/grab-data-from-the-highest-count-last-week/94805 "2017-07-27T13:46:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jessxyz](https://avatars.discourse-cdn.com/v4/letter/j/c67d28/32.png) [@jessxyz](https://discuss.elastic.co/u/jessxyz)\
**Post date:** [July 27, 2017, 1:46pm UTC](https://discuss.elastic.co/t/grab-data-from-the-highest-count-last-week/94805/1 "2017-07-27T13:46:33Z")

</div>

I would like to use Timelion to plot a line graph showing the messages coming in throughout the day for the day that got the highest number of messages last week.  
So for example, if my total message count for last week was  
7/17: 100  
7/18: 20  
7/19: 80  
7/20: 250  
7/21: 89

I would take July 20th's data and plot the messages coming in throughout the day. How can I figure out which day to take and then plot it?

---

<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:** [July 27, 2017, 8:19pm UTC](https://discuss.elastic.co/t/grab-data-from-the-highest-count-last-week/94805/2 "2017-07-27T20:19:07Z")

</div>

TimeLion only plots the numerical values and not any messages/text. Do let us know if this is not your use case and add more info to your q.

Thanks  
Rashmi

---

<div class="post-metadata">

**Author:** ![jessxyz](https://avatars.discourse-cdn.com/v4/letter/j/c67d28/32.png) [@jessxyz](https://discuss.elastic.co/u/jessxyz)\
**Post date:** [August 1, 2017, 5:37pm UTC](https://discuss.elastic.co/t/grab-data-from-the-highest-count-last-week/94805/3 "2017-08-01T17:37:52Z")

</div>

Hi thank you for the reply.  
I meant to say that I would like to figure out which day in the last week had the most number of messages coming into elastic search. So for example if July 20 was the day that had the most number of messages coming in, I would like to graph a plot that gives me an indication of how many messages are coming in hourly (I am sending data in throughout the day)

---

<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:** [August 29, 2017, 5:38pm UTC](https://discuss.elastic.co/t/grab-data-from-the-highest-count-last-week/94805/4 "2017-08-29T17:38:02Z")

</div>

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