I came here for a help.
I want to visualise information from my DB table. Table and few records are shown on picture below.
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.