How to customize the aggregation method

Overview

Based on the type of variable selected (continuous or categorical) in the Rows drop down, a list of aggregation methods can be selected. One of the options available is Custom where the methods and display can be customized.

Content

Selecting Custom for the aggregation method will display a Template field where the aggregation method can be customized. In the Template field, a combination of aggregation method(s) and text can be entered. Text entered that is recognized as an aggregation method will display the value. Text entered that is not recognized as an aggregation method will display with the text. This is useful for formatting the display.

Actions

• Open the Design tab on the Data View Update page

• Select a variable in the first drop down under Rows

• Select Custom in the second drop down under Rows

• In the Template field, add the aggregation methods

  • Multiple methods can be entered on one line

  • The formatting used in the template will be used to format the values displayed

    • For example, entering the following in the template field: n, Med [IQR], M (SD)

    • Displays values like this: 55, 188.5 [66.1], 185.1 (54.2)

• Click Add