We have financial application which works on FIX protocol . users Sends order and our application sends the response back within few milliseconds , application also generate the log with processing time of each order .. Below is how we store Data in ES . We are interested generating the vertical graph for each FIX users with their corresponding OrderId and the time it took for our application to response back the order.
I want to understand what is the best way to convert and the milliseconds value to seconds or minute and show on the Y-axis with the time of order receive on the X-Axis .
Order Receive time , App response time milliseonds(us) , Order ID , Source IP , FIX USER
00:51:34.575 , 3860 , 36A301295, 192.168.1.1 , ABCFIX1
00:52:34.575 , 41256 , A12342524, 10.168.1.1 , XYZFIX2