Hi All,
I want to calculate total duration of running machine between strainer replacement.
I am trying with formula below but getting error.
$series.setMaximumDuration(500day).aggregate(totalDuration("h"), $capsules.setMaximumDuration(500day), startKey(), 500day).toStep()
Note:
Purple capsule is a running condition
Yellow capsule is a time range between strainer replacement
Red capsule is a strainer replacement period