Time difference between rows

Hi

I've been trying to solve my problem for a few days, but even with research on the forum, I can't seem to make it work. 

Concept :

I get pings from 7 machines at varying delays. These looks like this :

I am trying to calculate the availability of these machines in the last days. To date, I created a pie-chart that looked at the number of ping occurrences for each of the machine statuses (0-2-3-4-5-6, meaning stopped, running, in alarm, etc). The problem is that if the machine pings status "6" 60 times (every minute) for an hour, then pings status "2" once and then goes an hour without a ping, the pie-chart will show that status "6 " takes up 60 times more space, when it should be equal.
So I need to calculate the difference (in seconds) of time between two lines, per machine, since the last ping. Like this : 

I tried a couple of measure and calculated column, and the closest I got is this :

TimedifferenceMeasure = 
VAR CurrentIndex =
    MAX ( machine_status[id] )
VAR PreviousIndex =
    CALCULATE (
        MAX ( machine_status[id] ),
        FILTER ( machine_status, machine_status[id] < CurrentIndex )
    )
VAR difference =
    DATEDIFF (
        CALCULATE (
            MAX ( machine_status[Creation Time] ),
            FILTER ( ALL ( machine_status ), machine_status[id] = PreviousIndex )
        ),
        CALCULATE (
            MAX ( machine_status[Creation Time] ),
            FILTER ( ALL ( machine_status ), machine_status[id] = CurrentIndex )
        ),
        SECOND
    )
RETURN
    IF ( difference > 43200, 43200, difference )

(The purpose of the 43200 at the end is to limit the time per status to 12 hours. Skip that, the machine is usually closed)

Here's the link to my file :

https://umanomed-my.sharepoint.com/:u:/g/personal/anthony_laroche_umanomedical_com/EdvcvOQ7WWRMsPGb5iXmEj8BIf7WOpwn-PVyJOs1BZDE4Q?e=7Q2TyT

Thank you !