Calculate time between incidents
I am a newbie, thanks for helping
I have data in a table that contains a timestamp of incident creation time on each row.
I am trying to show the average time between occurrences.
Basically, I want to write a calculation that with give me the average time that have passed since the previous occurrence (row)
I know this is wrong, but Something like...?
(Row 2 'sys_create_time') - (Row 1 'sys_create_time')
(Row 3 'sys_create_time') - (Row 2 'sys_create_time')
average of all