Forum Discussion
Get data diff in table based on other records in the same table
Hallo. Clasic question. I have I Incidents times - Start and End. And I want to calculate system availability %. I need Date diff between only those rows where are not overlapping with other rec...
You are write!
This is the real exsample!\
In SQL world I would joint this table with callendar table and then count only thouse distinct seconds, were is mach.. Maybe something form this side?!?!?!?
tamerj1
Community Champion
Community ChampionThis requires concentration so mo chance today. No promises anyway. Meanwhile it would be great if you can share a sample file of 6-7 rows and manually indicate the expected result of each row
Private massage.