Versions Compared

Old Version 14

changes.mady.by.user Richard Marshall

Saved on

compared with

New Version 15

changes.mady.by.user Richard Marshall

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: ARSP-9: added analysisId column to both tables so 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 values from the 2 instances of the ResultGroup class found in the resultGroups attribute for each result are represented in separate pairs of columns ("groupingId1"/"groupId1" and "groupingId2"/"groupId2") so that each result is represented on a single row:

Dataset2
analysisIdoperationIdgroupingId1groupId1groupingId2groupId2rawValueformattedValue
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_1AnlsGrouping_02_SexAnlsGrouping_02_Sex_13333
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_1AnlsGrouping_02_SexAnlsGrouping_02_Sex_25353
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_2AnlsGrouping_02_SexAnlsGrouping_02_Sex_13434
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_2AnlsGrouping_02_SexAnlsGrouping_02_Sex_25050
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_3AnlsGrouping_02_SexAnlsGrouping_02_Sex_1444444
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nAnlsGrouping_01_TrtAnlsGrouping_01_Trt_3AnlsGrouping_02_SexAnlsGrouping_02_Sex_24040
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_1AnlsGrouping_02_SexAnlsGrouping_02_Sex_138.3720930232558( 38.4)
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_1AnlsGrouping_02_SexAnlsGrouping_02_Sex_261.6279069767442( 61.6)
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_2AnlsGrouping_02_SexAnlsGrouping_02_Sex_140.4761904761905( 40.5)
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_2AnlsGrouping_02_SexAnlsGrouping_02_Sex_259.5238095238095( 59.5)
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_3AnlsGrouping_02_SexAnlsGrouping_02_Sex_152.3809523809524( 52.4)
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pctAnlsGrouping_01_TrtAnlsGrouping_01_Trt_3AnlsGrouping_02_SexAnlsGrouping_02_Sex_247.6190476190476( 47.6)

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 groups:

Dataset2
analysisIdoperationIdoperation_labelgroupingId1grouping_label1groupId1group_label1groupingId2grouping_label2groupId2group_label2rawValueformattedValue
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_1PlaceboAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_1Male3333
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_1PlaceboAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_2Female5353
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_2Xanomeline Low DoseAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_1Male3434
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_2Xanomeline Low DoseAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_2Female5050
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_3Xanomeline High DoseAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_1Male444444
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_1_nnAnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_3Xanomeline High DoseAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_2Female4040
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_1PlaceboAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_1Male38.3720930232558( 38.4)
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_1PlaceboAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_2Female61.6279069767442( 61.6)
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_2Xanomeline Low DoseAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_1Male40.4761904761905( 40.5)
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_2Xanomeline Low DoseAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_2Female59.5238095238095( 59.5)
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_3Xanomeline High DoseAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_1Male52.3809523809524( 52.4)
An03_03_Sex_Summ_ByTrtMth01_CatVar_Summ_ByGrp_2_pct%AnlsGrouping_01_TrtTreatmentAnlsGrouping_01_Trt_3Xanomeline High DoseAnlsGrouping_02_SexSexAnlsGrouping_02_Sex_2Female47.6190476190476( 47.6)