Hello Gurus,
Below are the KPIs of MTTR and MTBF. The columns are as follows: Formula given by my business, Input, Custom Table, Logic given by PM consultant (Me). I just want to know whether the logic is correct or not. Also the unit of measure they want to get is in "DAYS". My technical person is still confusing after I gave the logic also. Please help me out. You can enter the given table also for reference. He wants that how he can get Available time, breakdown time and no. of breakdowns.
Thank you.
MTBF (Available time - Breakdown Time ) / No of breakdown Shift Date ZTPM_DETENTION Custom 1. Pass Shift date (SHIFT_DATE) in ZTPM_DETENTION where DCODE=007* & DETENTION_MIN <> 0.