Every minute, some data is collected at 2 computers:
I want to compare ONLY the RATE at which Count is increasing. So:COMPUTER1 COMPUTER2
UpdateTime Count UpdateTime Count
38:09.6 13,349,601 37:58.6 1,501,230
39:59.9 13,349,680 39:57.7 1,501,245
42:00.0 13,349,761 42:00.5 1,501,258
step 1. Kinda Normalize data by subtracting each row from first row. so data looks like:
step2. Merge datasets, but somehow keep each computer data separateCOMPUTER1 COMPUTER2
UpdateTime Count UpdateTime Count
38:09.6 0 37:58.6 0
39:59.9 79 39:57.7 15
42:00.0 160 42:00.5 28
step3. Plot this on graph (Time on X, Count on Y), so that Computer1 is Blue and Computer2 is Red color.UpdateTime Count
-37:58.6 0
38:09.6 0
-39:57.7 15
39:59.9 79
42:00.0 160
-42:00.5 28
How to do this simple way or any inbuilt mechanism etc.?
Bookmarks