Splitting event duration for every hour using start and end date

I'd like to plot the duration of activity of an event in a date histogram hourly .
For every event i have the start time, the end time and the duration ,
for example having this log event: "startDate=2018.11.09 08:30:00+0000,endDate=2018.11.09 10:30:02+0000,duration=PT2H2S" .
I'd know that is active in the hour8 for 30minute and in the hour9 for 1 hour and in the hour10 for 30minute and 2 second.

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