---
title: "Reports - Edit Row Group Settings"
slug: "reports-edit-row-group-settings"
updated: 2026-03-25T23:05:18Z
published: 2026-03-25T23:05:18Z
canonical: "knowledge.technolutions.net/reports-edit-row-group-settings"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Reports - Edit Row Group Settings

Many of these settings are correlated with a specific Type and Row Type, which is noted in the description.

| Setting | Description |
| --- | --- |
| **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](/v1/docs/formulas-in-reports). |
| **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](/v1/docs/formulas-in-reports). |
| **Number Format** | *(Data Table only)* Display values in a particular format. For more details see: - [docs.microsoft.com - Custom Numeric Format Strings](https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings) - the Number Format section in [Formulas in Reports](/v1/docs/formulas-in-reports#using-number-format-to-display-percentages) |
| **Variable Name** | Assign a unique variable to the row group for use in a formula. |