Step 5: Specify content details

Content details specify how to display values of an analysis variable; that is, the aggregation method for values. For example, you may want to show an actual value, a count of records with a value, a percentage of records with the value, and so on. You can specify multiple aggregation methods for an analysis variable; each aggregation method is represented in the report.

When you add an analysis variable to a report, the term Value appears by default as the aggregation method:

Value stands for First value, which is the default aggregation method. (It is used when no other aggregation method is selected.) When you change the aggregation method, an abbreviation of that aggregation method appears in the table cell. For example, if you select Count as the aggregation method, N appears in the table cell:

Note:

If the source table for a column or row can include multiple records per case, the count and unique count for the column or row can differ.

Percentages in the columns or rows can add up to greater than 100 percent. For example, the breakdown variable is PT severity. Adverse events data can include multiple records per case. Suppose that each of 10 cases has an event with the severity Mild, an event with the severity Moderate, and an event with the severity Severe. The count of cases with each severity is 10. The count of cases with any severity will also be 10. So the percentage of cases with each severity will be 10/10, which is 100%. The total of percentages for each severity would be 300%.

1. In the left navigation pane, hover on the Data Analysis icon (), then click Report Definitions.
2. On the Report Definitions page, accept the case series shown or click Browse to the right of Case Series to display the Select Case Series page and select a case series.
3. Click a Report Definition's Row Action menu (), then click Edit.
4. On the Edit Report Columns page, highlight the aggregation method that appears in the table cell below the analysis variable. You must click the aggregation method, not the column heading. You can choose more than one aggregation method for a variable.
5. Next to Content Details, click Select.
6. Select the desired aggregation methods and percentages. Available aggregation methods depend on the data type of a variable.
7. Click OK.

Aggregation methods for text or date variables

For an analysis variable with a data type of text or date, check one or more of the following check boxes. The abbreviation appears in the report column heading.

Check box	Abbreviation	Meaning
Count	N	The number of non-NULL values.
Count (Unique)	N (U)	The number of unique non-NULL values.
Row %	Row %	Count of non-unique values for the row and column/Count of non-unique values for the row for all columns. (There must be a column for All.)
Column %	Column %	Count of non-unique values for the column and row/Count of non-unique values for the column for all rows. (There must be a row for All.)
Overall %	Overall %	Count of non-unique values for the column and row/Count of non-unique values for all columns and all rows. (There must be a column for All and a row for All.)
Row % (Unique)	Row % (U)	Count of unique values for the row and column/Count of unique values for the row for all columns. (There must be a column for All.)
Column % (Unique)	Col % (U)	Count of unique values for the column and row/Count of unique values for the column for all rows. (There must be a row for All.)
Overall % (Unique)	% (U)	Count of unique values for the column and row/Count of unique values for all columns and all rows. (There must be a column for All and a row for All.)
All values	ALL	All values, including null values, separated by commas. Null values are shown as blanks, so you may see a list of values like "DrugA, , DrugC".
All values (excluding NULLs)	All	All values except null values, separated by commas.
Unique values	ALL (U)	Unique values (in ascending order), including NULL values, separated by commas. Null values are represented in the list by the string "null".
Unique values (excluding NULL)	All (U)	Unique values (in ascending order), excluding NULL values, separated by commas.
Unique values and counts	ALL (N)	Unique values (in ascending order), including NULL values, separated by commas; after each value is the count of the value. Null values are represented in the list by the string "null".
Unique values and counts (Excluding NULL)	All (N)	Unique values (in ascending order), excluding NULL values, separated by commas; after each value is the count of the value.
First value	Value	First non-NULL value from the database (for the case series or query being used). If you do not specify an aggregation method, this method is used by default.

Aggregation methods for numeric variables

For an analysis variable with a data type of number, check one or more of the following check boxes. The abbreviation appears in the report column heading.

Note:

If a case is counted in multiple columns or rows, a count in the All column or row is not necessarily the same as the total of counts in other columns or rows of the report. Also, percentages in the columns or rows can add up to greater than 100 percent.

Check box	Abbreviation	Meaning
Count	N	The number of non-NULL values.
Count (Unique)	N (U)	The number of unique non-NULL values.
Row %	Row %	Count of non-unique values for the row and column/Count of non-unique values for the row for all columns. (There must be a column for All.)
Column %	Col %	Count of non-unique values for the column and row/Count of non-unique values for the column for all rows. (There must be a row for All.)
Overall %	%	Count of non-unique values for the column and row/Count of non-unique values for all columns and all rows. (There must be a column for All and a row for All.)
Row % (Unique)	Row % (U)	Count of unique values for the row and column/Count of unique values for the row for all columns. (There must be a column for All.)
Column % (Unique)	Col % (U)	Count of unique values for the column and row/Count of unique values for the column for all rows. (There must be a row for All.)
Overall % (Unique)	% (U)	Count of unique values for the column and row/Count of unique values for all columns and all rows. (There must be a column for All and a row for All.)
Sum	Sum	The sum of the values.
Mean	Mean	The mean of the values.
Median	Median	The median of the values.
Standard Deviation	SD	The standard deviation of the values.
1st Quartile	Q1	The first quartile of the values.
3rd Quartile	Q3	The third quartile of the values.
Min	Min	The minimum value.
Max	Max	The maximum value.

For example, suppose that a report includes counts like this:

If you replace the counts in the report with row, column, and overall percentages, the report display changes to this: