Page History

...

The results for this analysis could be represented in tabular format as shown in the following table, where the groupingId, groupId and groupValue values from the 3 two 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

class	dataset

operation_idoperationId	groupingId1	groupId1	groupingId2	groupValue2	groupingId3	groupValue3	rawValue	formattedValue
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
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)
Mth01_CatVar_Summ_ByGrp_1_n	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_1	AnlsGrouping_06_Soc	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	DIARRHOEA	9	9
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)
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
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)
Mth01_CatVar_Summ_ByGrp_1_n	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_2	AnlsGrouping_06_Soc	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	DIARRHOEA	4	4
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)
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
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)
Mth01_CatVar_Summ_ByGrp_1_n	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_3	AnlsGrouping_06_Soc	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	DIARRHOEA	4	4
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 additional descriptive information from the definitions of the operations, grouping factors, and predefined groups:

Xfancy

class	dataset

operation_idoperationId	operation_label	groupingId1	grouping_label1	groupId1	group_label1	groupingId2	grouping_label2	groupValue2	groupingId3	grouping_label3	groupValue3	rawValue	formattedValue
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
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)
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
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)
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
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)
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
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)
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
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)
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
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)

...

Page tree

Versions Compared

Old Version 3

New Version 4

Key