Reports - Edit Row Group Settings

Type 

Determine the visual presentation of the row:

• Data Table - Displays numerical data in a table

• Chart - Represents aggregate data graphically

Heading

Provide the row with a name to display in the report.

Row Type

Determine the approach for calculating data in the row.

• Group By - Returns one row for each unique value in the export(s) selected. Most appropriate for reporting data driven by a defined prompt list (e.g. major, campus, term). Useful for cross-tab reporting.

• Aggregate - Returns a table row of values based on the Function selected. See the “Function” setting below for a list of the standard mathematical functions available.

• Distribution - Group and display the distribution of data values based on defined intervals.

• Formula - Display data based on a formula.

Null Values

(Group By) Determine if null/missing values should be displayed.

Series Total

(Group By table) Check this setting to show the series total as a row in the data table.

Chart Type

(Chart) Choose from the following options:

• Pie

• Donut

• Bar

• Column

• Line

• Timeline

• Geo Map (US State)

• Geo Map (Canada Province)

• Geo Map (World)

• Geo Map (Markers)

• Scatter

Function

(Aggregate) Functions available:

• Average

• Median

• Maximum

• Minimum

• Count

• Sum

• Standard Deviation

• Standard Deviation (Population)

• Variance

• Variance (Population)

(Distribution) Select the Continuous options for continuous data (e.g. length of time), and Discrete for discrete data (e.g. test scores).

• Continuous Ascending

• Continuous Descending

• Discrete Ascending

• Discrete Descending

(Timeline) Note that if a Timeline chart is paired with a Row Type of Aggregate or Distribution, two Function settings will appear.

• Day

• Day (Cumulative)

• Month

• Month (Cumulative)

• Fiscal Day of Year

• Fiscal Day of Year (Cumulative)

Trendlines

(Chart) Select one of the following options:

• None

• Linear

• Exponential

• Polynomial

Intervals

(Distribution only) Define the interval by which the data values should be split. If the values should be displayed according to deciles, enter 10; quartiles, 4, etc.

Formula

(Formula rows only) Enter the formula.

Number Format

(Data Table only) Display values in a particular format. For more details see:

• docs.microsoft.com - Custom Numeric Format Strings

• the Number Format section in Formulas in Reports

Variable Name

Assign a unique variable to the row group for use in a formula.