# Visualize in Kibana

**URL:** <https://discuss.elastic.co/t/visualize-in-kibana/94895>\
**Category:** Kibana\
**Created:** [July 28, 2017, 4:11am UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895 "2017-07-28T04:11:19Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![truongdqse03303](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/truongdqse03303/32/22605_2.png) [@truongdqse03303](https://discuss.elastic.co/u/truongdqse03303)\
**Post date:** [July 28, 2017, 4:11am UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895/1 "2017-07-28T04:11:19Z")

</div>

Hi Kibana team. I'm newbie at ELK stack, i just installed and run a first step and now i have a question:  
Is it possible to visualize the data by specify time everyday?  
for example i want to check hits log from 10-11h everyday in 1 visualize so i can compare it.  
If it's possible please teach me, ty

---

<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 28, 2017, 5:22am UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895/2 "2017-07-28T05:22:17Z")

</div>

> [@truongdqse03303](#):
>
> the data by specify tim

yes, it is possible to visualize the data by specific time. You could do this by picking the time filter option in visualize . The time filter restricts the search results to a specific time period. You can set a time filter if your index contains time-based events and a time-field is configured for the selected index pattern.

By default the time filter is set to the last 15 minutes. You can use the Time Picker to change the time filter or select a specific time interval or time range in the histogram at the top of the page.

More information can be found here: [Set the time range | Kibana Guide [8.11] | Elastic](https://www.elastic.co/guide/en/kibana/current/set-time-filter.html)

Let us know if you need more information.  
Thanks  
Rashmi

---

<div class="post-metadata">

**Author:** ![truongdqse03303](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/truongdqse03303/32/22605_2.png) [@truongdqse03303](https://discuss.elastic.co/u/truongdqse03303)\
**Post date:** [July 28, 2017, 7:27am UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895/3 "2017-07-28T07:27:08Z")

</div>

Hi @rashmi  
I have try the specific time that kibana tool give me at top right but i want to see the result each day at one time in one result data not by click at the \< button  
The result like ![1](https://us1.discourse-cdn.com/elastic/original/3X/d/4/d4d45da5b5af2cfa601d6f6b9f40b11ac7a6f23b.PNG)  
Can i do it with kibana tool?  
Thanks

---

<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 28, 2017, 4:53pm UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895/4 "2017-07-28T16:53:42Z")

</div>

> [@truongdqse03303](#):
>
> na tool?
> 
> Thanks

Yes, this could be done by using the painless script . For example, I used Filebeat data. Create a scripted field with painless as shown doc['json.REALTIme\_TimeSTAMP'].date.hourOfDay and use this to plot against the x-axis as shown in the visualization.  
Also add the sub-aggregation- Range - Field hour for the specific time of the day you want to plot the graph against. I chose between 10-11 and as you can see the graph is plotted hourly. You can keep adding the hour fields for the range you want.

Hope this helps.  
Thanks  
Rashmi

 ![image (1)](https://us1.discourse-cdn.com/elastic/original/3X/5/b/5b1aefd35a873bb939fb9ec941f820525ae6ac71.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/7/f751cfa5b985a369081554066d2bd99571568d66.png)

---

<div class="post-metadata">

**Author:** ![truongdqse03303](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/truongdqse03303/32/22605_2.png) [@truongdqse03303](https://discuss.elastic.co/u/truongdqse03303)\
**Post date:** [July 29, 2017, 2:14am UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895/5 "2017-07-29T02:14:54Z")

</div>

Thanks @rashmi  
That's exactly what i want.  
Ty for good support again 🙂

---

<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:** [August 1, 2017, 9:38pm UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895/6 "2017-08-01T21:38:02Z")

</div>

glad my response helped u.

Thanks  
Rashmi

---

<div class="post-metadata">

**Author:** ![truongdqse03303](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/truongdqse03303/32/22605_2.png) [@truongdqse03303](https://discuss.elastic.co/u/truongdqse03303)\
**Post date:** [August 10, 2017, 3:22am UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895/7 "2017-08-10T03:22:55Z")

</div>

Hi @rashmi im back 🙂  
I have follow your step and i have a trouble with the scripted field here  
My scripted Field:

 ![11](https://us1.discourse-cdn.com/elastic/original/3X/c/2/c2524bcb6f77394d8dd8f803d256d46fe6e2f498.PNG)  
Without the Split Series it's the normal result per day  
 ![12](https://us1.discourse-cdn.com/elastic/original/3X/7/c/7c9339b3eb7f553e018d513430f455bc32f125d1.PNG)  
But when i add the range hour follow you, it's error  
 ![13](https://us1.discourse-cdn.com/elastic/original/3X/8/5/85af4baf4c417c0d24b76ff5fa0f80a839a6fd07.PNG) ![14](https://us1.discourse-cdn.com/elastic/original/3X/f/9/f9332af1627597f08a3cf7ebba39521bf8ef585f.PNG)  
Can you help me with this. Thank you

---

<div class="post-metadata">

**Author:** ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)\
**Post date:** [August 10, 2017, 10:23am UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895/8 "2017-08-10T10:23:05Z")

</div>

The quote characters used in your `Script` field look like typographic quotes instead of the expected single or double quotes (`'` or `"`). Try using normal single quotes.

---

<div class="post-metadata">

**Author:** ![truongdqse03303](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/truongdqse03303/32/22605_2.png) [@truongdqse03303](https://discuss.elastic.co/u/truongdqse03303)\
**Post date:** [August 11, 2017, 8:58am UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895/9 "2017-08-11T08:58:36Z")

</div>

Hi @weltenwort  
After follow your advice i can visualize with scripted field.  
I can filter with my scripted field doc['Time'].date.hourOfDay  
But when i choose range 1-2 it become 8-9 in the result, i think it's because of my GMT +7 so i try  
doc['Time'].date.hourOfDay() - 7  
(doc['Time'].date.hourOfDay) - 7  
doc['Time'].date.hourOfDay - 7  
event in the Popularity (the field i dont know exactly what it doing)  
Still not work. Can you help me with this.  
Thanks

---

<div class="post-metadata">

**Author:** ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)\
**Post date:** [August 11, 2017, 11:32am UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895/10 "2017-08-11T11:32:08Z")

</div>

Yes, the time should be in UTC by default. Using `doc['Time'].date.hourOfDay + 7` in the script field should work:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/2/a218e953635f62ff228464d43f789611d6526681.png)

The popularity field just influences the sorting of the field within the field list of the discover view and does not influence its functionality.

---

<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:** [September 8, 2017, 11:32am UTC](https://discuss.elastic.co/t/visualize-in-kibana/94895/11 "2017-09-08T11:32:17Z")

</div>

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