Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: ARSP-9: added analysisId column to both tables so that they can be referred to as ARDs

...

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
classdataset
analysisIdoperationIdgroupingId1groupId1groupingId2groupValue2groupingId3groupValue3rawValueformattedValue
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_1AnlsGrouping_06_SocCARDIAC DISORDERSAnlsGrouping_07_PtATRIAL FIBRILLATION11
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_1AnlsGrouping_06_SocCARDIAC DISORDERSAnlsGrouping_07_PtATRIAL FIBRILLATION1.1628(  1.2)
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_1AnlsGrouping_06_SocGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtDIARRHOEA99
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_1AnlsGrouping_06_SocGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtDIARRHOEA10.4651( 10.5)
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_2AnlsGrouping_06_SocCARDIAC DISORDERSAnlsGrouping_07_PtATRIAL FIBRILLATION1111
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_2AnlsGrouping_06_SocCARDIAC DISORDERSAnlsGrouping_07_PtATRIAL FIBRILLATION1.1905(  1.2)
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_2AnlsGrouping_06_SocGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtDIARRHOEA44
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_2AnlsGrouping_06_SocGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtDIARRHOEA4.7619(  4.8)
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_3AnlsGrouping_06_SocCARDIAC DISORDERSAnlsGrouping_07_PtATRIAL FIBRILLATION33
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_3AnlsGrouping_06_SocCARDIAC DISORDERSAnlsGrouping_07_PtATRIAL FIBRILLATION3.5714(  3.6)
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_3AnlsGrouping_06_SocGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtDIARRHOEA444
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_3AnlsGrouping_06_SocGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtDIARRHOEA4.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
classdataset
analysisIdoperationIdoperation_labelgroupingId1grouping_label1groupId1group_label1groupingId2grouping_label2groupValue2groupingId3grouping_label3groupValue3rawValueformattedValue
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_1PlaceboAnlsGrouping_06_SocSystem Organ ClassCARDIAC DISORDERSAnlsGrouping_07_PtPreferred TermATRIAL FIBRILLATION11
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_1PlaceboAnlsGrouping_06_SocSystem Organ ClassCARDIAC DISORDERSAnlsGrouping_07_PtPreferred TermATRIAL FIBRILLATION1.1628(  1.2)
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_1PlaceboAnlsGrouping_06_SocSystem Organ ClassGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtPreferred TermDIARRHOEA99
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_1PlaceboAnlsGrouping_06_SocSystem Organ ClassGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtPreferred TermDIARRHOEA10.4651( 10.5)
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_2Xanomeline Low DoseAnlsGrouping_06_SocSystem Organ ClassCARDIAC DISORDERSAnlsGrouping_07_PtPreferred TermATRIAL FIBRILLATION1111
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_2Xanomeline Low DoseAnlsGrouping_06_SocSystem Organ ClassCARDIAC DISORDERSAnlsGrouping_07_PtPreferred TermATRIAL FIBRILLATION1.1905(  1.2)
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_2Xanomeline Low DoseAnlsGrouping_06_SocSystem Organ ClassGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtPreferred TermDIARRHOEA44
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_2Xanomeline Low DoseAnlsGrouping_06_SocSystem Organ ClassGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtPreferred TermDIARRHOEA4.7619(  4.8)
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_3Xanomeline High DoseAnlsGrouping_06_SocSystem Organ ClassCARDIAC DISORDERSAnlsGrouping_07_PtPreferred TermATRIAL FIBRILLATION33
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_3Xanomeline High DoseAnlsGrouping_06_SocSystem Organ ClassCARDIAC DISORDERSAnlsGrouping_07_PtPreferred TermATRIAL FIBRILLATION3.5714(  3.6)
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_3Xanomeline High DoseAnlsGrouping_06_SocSystem Organ ClassGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtPreferred TermDIARRHOEA44
An07_10_SocPt_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_3Xanomeline High DoseAnlsGrouping_06_SocSystem Organ ClassGASTROINTESTINAL DISORDERSAnlsGrouping_07_PtPreferred TermDIARRHOEA4.7619(  4.8)

...