...
The results for this analysis could be represented in tabular format as shown in the following table, where the value of the id attribute of the analysis is shown in the "analysisId" column and the groupingId and groupId or groupValue values from the 3 instances of the ResultGroup class found in the resultGroups attribute for each result are represented in separate pairs of columns ("groupingId1"/"groupId1", "groupingId2"/"groupValue2" and "groupingId3"/"groupValue3") so that each result is represented on a single row:
Xfancy |
---|
|
analysisId | operationId | groupingId1 | groupId1 | groupingId2 | groupValue2 | groupingId3 | groupValue3 | rawValue | formattedValue |
---|
An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_1 | AnlsGrouping_06_Soc | CARDIAC DISORDERS | AnlsGrouping_07_Pt | ATRIAL FIBRILLATION | 1 | 1 | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_1 | AnlsGrouping_06_Soc | CARDIAC DISORDERS | AnlsGrouping_07_Pt | ATRIAL FIBRILLATION | 1.1628 | ( 1.2) | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_1 | AnlsGrouping_06_Soc | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | DIARRHOEA | 9 | 9 | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_1 | AnlsGrouping_06_Soc | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | DIARRHOEA | 10.4651 | ( 10.5) | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_2 | AnlsGrouping_06_Soc | CARDIAC DISORDERS | AnlsGrouping_07_Pt | ATRIAL FIBRILLATION | 1 | 1 | | 1 | 1 | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_2 | AnlsGrouping_06_Soc | CARDIAC DISORDERS | AnlsGrouping_07_Pt | ATRIAL FIBRILLATION | 1.1905 | ( 1.2) | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_2 | AnlsGrouping_06_Soc | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | DIARRHOEA | 4 | 4 | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_2 | AnlsGrouping_06_Soc | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | DIARRHOEA | 4.7619 | ( 4.8) | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_3 | AnlsGrouping_06_Soc | CARDIAC DISORDERS | AnlsGrouping_07_Pt | ATRIAL FIBRILLATION | 3 | 3 | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_3 | AnlsGrouping_06_Soc | CARDIAC DISORDERS | AnlsGrouping_07_Pt | ATRIAL FIBRILLATION | 3.5714 | ( 3.6) | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_3 | AnlsGrouping_06_Soc | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | DIARRHOEA | 4 | 4 | 4 | | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_3 | AnlsGrouping_06_Soc | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | DIARRHOEA | 4.7619 | ( 4.8) |
|
Alternatively, to aid readability, each of the identifier values could be used to retrieve and include the label (or any other descriptive information) from the definitions of the operations, grouping factors, and predefined groups:
Xfancy |
---|
|
analysisId | operationId | operation_label | groupingId1 | grouping_label1 | groupId1 | group_label1 | groupingId2 | grouping_label2 | groupValue2 | groupingId3 | grouping_label3 | groupValue3 | rawValue | formattedValue |
---|
An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_1 | Placebo | AnlsGrouping_06_Soc | System Organ Class | CARDIAC DISORDERS | AnlsGrouping_07_Pt | Preferred Term | ATRIAL FIBRILLATION | 1 | 1 | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_1 | Placebo | AnlsGrouping_06_Soc | System Organ Class | CARDIAC DISORDERS | AnlsGrouping_07_Pt | Preferred Term | ATRIAL FIBRILLATION | 1.1628 | ( 1.2) | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_1 | Placebo | AnlsGrouping_06_Soc | System Organ Class | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | Preferred Term | DIARRHOEA | 9 | 9 | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_1 | Placebo | AnlsGrouping_06_Soc | System Organ Class | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | Preferred Term | DIARRHOEA | 10.4651 | ( 10.5) | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_2 | Xanomeline Low Dose | AnlsGrouping_06_Soc | System Organ Class | CARDIAC DISORDERS | AnlsGrouping_07_Pt | Preferred Term | ATRIAL FIBRILLATION | 1 | 1 | | 1 | 1 | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_2 | Xanomeline Low Dose | AnlsGrouping_06_Soc | System Organ Class | CARDIAC DISORDERS | AnlsGrouping_07_Pt | Preferred Term | ATRIAL FIBRILLATION | 1.1905 | ( 1.2) | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_2 | Xanomeline Low Dose | AnlsGrouping_06_Soc | System Organ Class | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | Preferred Term | DIARRHOEA | 4 | 4 | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_2 | Xanomeline Low Dose | AnlsGrouping_06_Soc | System Organ Class | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | Preferred Term | DIARRHOEA | 4.7619 | ( 4.8) | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_3 | Xanomeline High Dose | AnlsGrouping_06_Soc | System Organ Class | CARDIAC DISORDERS | AnlsGrouping_07_Pt | Preferred Term | ATRIAL FIBRILLATION | 3 | 3 | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_3 | Xanomeline High Dose | AnlsGrouping_06_Soc | System Organ Class | CARDIAC DISORDERS | AnlsGrouping_07_Pt | Preferred Term | ATRIAL FIBRILLATION | 3.5714 | ( 3.6) | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_3 | Xanomeline High Dose | AnlsGrouping_06_Soc | System Organ Class | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | Preferred Term | DIARRHOEA | 4 | 4 | An07_10_SocPt_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_3 | Xanomeline High Dose | AnlsGrouping_06_Soc | System Organ Class | GASTROINTESTINAL DISORDERS | AnlsGrouping_07_Pt | Preferred Term | DIARRHOEA | 4.7619 | ( 4.8) |
|
...