Kibana and Timelion feature, display startTime and EndTime for time interval on graph

Elastic Stack Elasticsearch
1

Hi

I would like to draw a graph to see the sum of number of active Jobs across hourly time interval. From the sample below, it shows that there are 5 ES documents, with 3 fields, “name”, “StartTime” and “EndTime”. The period between start time and end time means the active period of the job.

And I want to create a graph in kibana or timelion, that can show me number of active job that looks like the graph below with the two timestamps that have been provided below. I still haven't be able to find a way to use those two timestamps to span across different time interval below.

jobStarted
jobStarted1600×1232 135 KB

activeJob_timelion
activeJob_timelion1600×738 67 KB

Doc1

Name : JobA

StartTime: 2020-03-04T01:00:00.000Z

EndTime: 2020-03-04T03:00:00.000Z

Doc2

Name:JobB

StartTime: 2020-03-04T02:00:00.000Z

EndTime: 2020-03-04T04:00:00.000Z

Doc3

Name:JobC

StartTime: 2020-03-04T02:00:00.000Z

EndTime: 2020-03-04T05:00:00.000Z

Doc4

Name:JobD

StartTime: 2020-03-04T03:00:00.000Z

EndTime: 2020-03-04T04:00:00.000Z

Doc5

Name:JobE

StartTime: 2020-03-04T04:00:00.000Z

EndTime: 2020-03-04T06:00:00.000Z

2

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