Create graph based on start & stop time

Grafana
1

Hi,
I’m new to Grafana. I’m trying to show the below csv data as chart. We need to calculate the duration based on end time-start time. Kindly suggest how to achieve that. The data is in elasticsearch DB.

Bot ID,Status,Time Stamp
Bot1,start,2019-12-21 01:00:00
Bot1,stop,2019-12-21 02:00:00
Bot1,start,2019-12-21 07:00:00
Bot1,stop,2019-12-21 09:45:00
Bot1,start,2019-12-21 11:30:00
Bot1,stop,2019-12-21 13:30:00
Bot1,start,2019-12-21 17:30:00
Bot1,stop,2019-12-21 18:35:00
Bot1,start,2019-12-22 01:00:00
Bot1,stop,2019-12-22 02:00:00
Bot1,start,2019-12-22 07:00:00
Bot1,stop,2019-12-22 09:45:00
Bot1,start,2019-12-22 11:30:00
Bot1,stop,2019-12-22 13:30:00
Bot1,start,2019-12-22 17:30:00
Bot1,stop,2019-12-22 18:35:00

2

hi,
Did you get an answer to this. I have a similar need where I need to job duration (Start - end time) as a chart. Is there a suitable chart to show the same