AnsweredAssumed Answered

Graphing in FM12 - Medical data

Question asked by DrewTenenholz on Jul 27, 2012
Latest reply on Jul 30, 2012 by DrewTenenholz

All --

 

I'm looking into the new using native graphing abilities in FM12 for a solution and have a question. Given the dummy data set for a dummy patient's liver function tests below, is it possible to graph the data in the same way that is already being done using the xmChart plugin? I've included screen shots for xmChart followed by FM12.

 

The main thing I'm seeing right now is that when a specific test was done on certain discountinuous dates, the line that connects the data points is also discontinuous. This is not an acceptable way to display the data. Any thoughts on how to make the chart look right?

 

Thanks,

Drew Tenenholz

 

The original Data Set

Header 1Header 2Header 3
DateTestData
08/03/09ALT35
03/04/10ALT11
04/25/10ALT17
10/07/10ALT22
10/11/10ALT30
01/16/12ALT9
05/12/12ALT19



09/03/08ALT (SGPT)29
01/20/09ALT (SGPT)24
11/28/11ALT (SGPT)16



06/12/09AST15
08/03/09AST19
03/04/10AST14
04/25/10AST37
10/07/10AST18
10/11/10AST21
01/16/12AST11
05/12/12AST20



09/03/08AST (SGOT)28
01/20/09AST (SGOT)24
11/28/11AST (SGOT)20



12/27/10SGOT (AST)24

 

 

The Data set arranged to explicitly give values for each test for each unique date from the data above

DateALTALT (SGPT)ASTAST (SGOT)SGOT (AST)
09/03/08
29
28
01/20/09
24
24
06/12/09

15

08/03/0935
19

03/04/1011
14

04/25/1017
37

10/07/1022
18

10/11/1030
21

12/27/10



24
11/28/11
16
20
01/16/129
11

05/12/1219
20

Outcomes