Overcome Uncertain Initial Value quality of expression tag

[pascal.fragnoud]

I seem to remember this...
I also remember that Phil provided a more robust solution:

Counter like tag with cumulated value

The reliable way to do this is to record state changes in an event table. Then use LEAD or LAG functions in the DB to get intervals per state, clipping to the start of shift. Sum those intervals while grouping by state. With an index on t_stamp, your DB will calculate this blisteringly fast. Select state, sum(event_duration) as duration From ( Select state, nextTS - clipped as event_duration From ( Select state , case t_stamp < :shift_start_ts then :shift_start_ts else t_stamp …

I warned you that this was only a little experiment I was doing for fun.