Hi all,
first of all thanks for any help with this guys,
as you can see in the table below Equipment M01_0001_3GR_1 fails 7 times with a comms error.
each error has a raised time and a clearance time.
I want to count the faults that occur within 3 days of one another.
in my table I want to have Fault Classification as a dimension and the above calculation as the expression.