# Visualisation of changes during the day

**URL:** <https://discuss.elastic.co/t/visualisation-of-changes-during-the-day/123428>\
**Category:** Kibana\
**Created:** [March 11, 2018, 2:08pm UTC](https://discuss.elastic.co/t/visualisation-of-changes-during-the-day/123428 "2018-03-11T14:08:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JozefPaulisin](https://avatars.discourse-cdn.com/v4/letter/j/958977/32.png) [@JozefPaulisin](https://discuss.elastic.co/u/JozefPaulisin)\
**Post date:** [March 11, 2018, 2:08pm UTC](https://discuss.elastic.co/t/visualisation-of-changes-during-the-day/123428/1 "2018-03-11T14:08:40Z")

</div>

Hello,  
I came here for a help.

I want to visualise information from my DB table. Table and few records are shown on picture below.

![image](https://us1.discourse-cdn.com/elastic/original/3X/0/7/0716010fea36adc19363a589c7b5aac7a2452c9b.png)

Data are imported in kibana by bulk import, so I'm not feeding them continuously.

Each record in DB represents one state, that is unique at for bounded timerange (interval could be described: \<begin (timestamp), end(timestamp)) ).

The desired visualisation should show the changes during the day. My assumption is that in filter will be picked day or dayrange, for which will be showed the 'timeline' of states. In a visualisation I want to see the start and end time of state a its id (state\_id).

I appreciate any help(which graph type to use, approach how to aggregate data, ..) because I'm totally new in ELK.

Thanks.

Regards,  
Jozef

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [March 12, 2018, 1:41pm UTC](https://discuss.elastic.co/t/visualisation-of-changes-during-the-day/123428/2 "2018-03-12T13:41:04Z")

</div>

Hey @JozefPaulisin, the built-in Visualizations don't support this type of graph where you specify the start and end times for a specific series. You can create a Date Histogram visualization quite easily using just the begin dates, but it's not going to give you exactly what you want.

I'd suggest experimenting with the Vertical Bar visualization to see if it's close enough to what you're looking for, and if that doesn't satisfy your needs looking into Vega support to create this custom graph, but it's a rather advanced topic. The following video should get you started: [https://www.youtube.com/watch?v=lQGCipY3th8](https://www.youtube.com/watch?v=lQGCipY3th8)

---

<div class="post-metadata">

**Author:** ![JozefPaulisin](https://avatars.discourse-cdn.com/v4/letter/j/958977/32.png) [@JozefPaulisin](https://discuss.elastic.co/u/JozefPaulisin)\
**Post date:** [March 12, 2018, 6:44pm UTC](https://discuss.elastic.co/t/visualisation-of-changes-during-the-day/123428/3 "2018-03-12T18:44:59Z")

</div>

Thank you @Brandon_Kobel,

I will try to create something according to your suggestions.

---

<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:** [April 9, 2018, 6:45pm UTC](https://discuss.elastic.co/t/visualisation-of-changes-during-the-day/123428/4 "2018-04-09T18:45:25Z")

</div>

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