Hello Community,
sorry for the strange topic, but i dont know how to describe it better in a few words.
I really am struggling since a few days with this problem and hope you are able to help me.
What i am trying to do is linking different timestamps in form of StartTime and EndTime to a MachineID.
I have one Table with ProductionData and StartTime and EndTime of Production as well as the MachineID.
I have another Table with LossData such as Machine Breakdowns also with StartTime and EndTime as well as the MachineID.
Breakdowns can occur everytime (also if no production is running).
The end Goal is to have lets say 24h in which i can calculated how much of the 24h was production or breakdown for a specific Machine.
I tried Intervalmatch without success, and also tried creating separate autogenerated calendars which break the timestamps down to minutes.
Do you have any idea what i could do? A new thinking approach would be great to hear.
All the best & thank you in advance