FreelanceReinhard, Thank you for your feedback/questions. Sorry for the typos. as i can not post the original data, i typed in a hurry. To start with we are analyzing data within a day/date. If process runs for more than a day then we ignore that process for now. Basically this report is only for a single date. following is the corrected report format and data: This is how my data looks like: Server PID Date Proc_Start_hour Proc_End_hour Srv1 1 Oct1 0 9 Srv1 2 Oct1 1 2 Srv1 3 Oct1 2 23 Srv1 4 Oct1 3 11 Srv1 5 Oct1 4 4 Srv1 6 Oct1 5 22 This is the expected report format: Server Date Time +NewZombies -ZombiesDied TotalZombies Srv1 Oct1 00:00 1 0 1 Srv1 Oct1 01:00 1 0 2 (1 from prior hour + 1 new – 0 died = 2 remaining) Srv1 Oct1 02:00 1 1 2 (2 from prior hour + 1 new – 1 died = 2 remaining) Srv1 Oct1 03:00 1 0 3 (2 from prior hour + 1 new – 0 died = 3 remaining) Srv1 Oct1 04:00 1 0 3 (3 from prior hour + 1 new –1 died = 3 remaining) Srv1 Oct1 05:00 1 0 4 (3 from prior hour + 1 new – 0 died = 4 remaining)
... View more