--- title: "Grouping Requests" slug: "grouping-requests" updated: 2024-09-10T10:16:02Z published: 2024-09-10T10:16:02Z canonical: "docs.avontus.com/grouping-requests" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.avontus.com/llms.txt > Use this file to discover all available pages before exploring further. # Grouping Requests It is possible to group a column by dragging a column from the table to the group panel section. To do this, drag the selected column header and place it in between the toolbar and the table (see below). You will then be able to group by that column. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/group.gif) The Requests table will then be grouped by Activity ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/46d4e6d7-78fb-427a-81ad-7a14d5bb2320.png) **Note: You can group by more than one column. Simply, drag a column to the group panel section. In the example below, Activity Type and Assigned to columns are being grouped.** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/40b38133-719b-4089-88ed-6fd0993a0fa3.png)** When you group by a column, each unique entry in the column will have its own group. For example, in the **Activity** **Type** column there are three unique entries (**Build**, **Modification**, **Dismantle**). Each of the entries will be given its own group, as shown below. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/bd759015-d8e4-4b44-8386-dc2300795fc0.png) **Note: Alternatively, to group a column you can right-click a column heading and select Group By This Column.** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/9b18b30b-b948-423c-9736-8f5fd0874ef9.png)** Click on a group to expand it. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/bd759015-d8e4-4b44-8386-dc2300795fc0.png) Expanding the **Build Activity Type** group will display all requests with the **Activity** **Type** set to **Build.** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/7922d24e-4b53-42f9-b7b5-bd042cf98a8d.png)** By right-clicking on the grouped column you can modify how the information is displayed in the table below. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/fc66510e-9302-4e6e-8a1d-03800d3c493b.png) **Full Expand** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/06c07e15-3234-4e0a-9e98-b8cfbfecb80d.png) Expand all entries in the table to show further information for each group. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/0034f8a5-48b2-49b0-848b-6445b7c5a726.png) **Full Collapse** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/ab2d33d3-d933-4967-a4ce-22ba4ceec9e3.png)** Collapse all groups in the table. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/bd759015-d8e4-4b44-8386-dc2300795fc0.png) **Sort** **Ascending** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/e2d3b478-a900-4544-9c9e-b77164e6d846.png)** Sort the groups in ascending order either alphabetically or numerically. **Sort** **Descending** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/3a78b0f3-4ce6-4e0f-a6fc-052c92a0008e.png)** Sort the groups in descending order either alphabetically or numerically. **Clear** **Sorting** Clear any column sorting currently active. **Sort by Summary** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/a80e1c5b-d62e-4147-bebf-69fd7e04accf.png)** A summary is a brief overview of what content is held within that group. This summary contains information about that group such as the number of rows within that group and the maximum or minimum entry in a group from a selected column. For example, when grouping by **Status**, you could select to display information from the **Area** column for each group. The summary would then provide an overview of the data pulled from the **Area** column including the number of entries in each group and the minimum and/or maximum status of each group. **Note: To Sort by Summary, enable the Group Summary Editor (see below).** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/c26a8e32-eb4b-4e2a-a0bf-f19f127393e8.png)** **Group Summary Editor** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/26d6e4d6-a56f-47dc-a33e-0a740873c058.png)** When grouping, this option allows the user to adjust what is displayed in the group summary, such as the maximum and minimum value within that group and the number of rows within the group. To the left-hand side are the columns and to the right are the summary options. Select a column on the left and this will be the column where the information is pulled from. Selecting **Max** and **Min** will enable **Max by – Ascending**, **Max by - Descending**, **Min By – Ascending**, and **Min by – Descending** summary options for the chosen column. In the example below, the maximum area of the group will be displayed for each group. Click the **Show row count** to enable a count for the number of rows within the group. **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/ae0c5d9b-8c4c-43be-abfe-017562552187.png)** **Note: The Max by Area summary options will change depending upon the selected column. For example, selecting Approver in the Group Summary Editor will set the summary option to 'Max by Approver'.** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/0c384cc4-5da3-41b6-9966-f1027c4fc6ee.png)** **Order** The **Order** tab of the **Group** **Summary** **Editor** allows the user to modify how the summary is presented. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/50960ea2-156f-4f56-9be0-8ba841e710a8.png) The box below lists the columns you selected in the **Items** tab. You can use the arrow buttons to the right to adjust in which order the summaries are displayed. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/142dac65-f35f-42b3-8fc9-f4fa5cefc04d.png) If you selected to display the summaries as defined in the image above, then the group summary will appear like so in the main table. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/23b361ac-00b3-4aff-a5e5-e55e98df6b7e.png) The **Prefix**, **Display format text**, and **Suffix** options allow the user to adjust the wording of the summary. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/04e90250-84c2-448b-a446-52cf4d194279.png) **Prefix** is the text before the maximum/minimum displayed content for the group. **Display format text** is used with the group row count and this adjusts how the numbers are displayed. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/d5f00837-5574-4af9-bf3b-d42b6def4eac.png) The **Suffix** is the text that goes after the maximum/minimum displayed content for the group. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/32c0dc66-6853-41e6-ab4a-5c9bee6f77cc.png) **Note: Remember to include a space after the Prefix and before the Suffix.** **Note: 100 is an example and the actual number will be the number of rows in the group.** **Count by Ascending** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/dde50f01-64b4-4e81-99ae-c3c2c9745332.png)** When grouping, count the number of entries in a group and sort by ascending order. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/3f8bd2db-fef1-4d5c-a388-62c9cbf8b73a.png) **Count by Descending** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/94f934b4-8d59-4a79-91ef-82b713c3286d.png)** When grouping, count the number of entries in a group and sort by descending order. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/9301cf46-d4bd-420c-9a20-e70766369081.png) **Max/Min By Activity Type Ascending** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/1e40bf65-1978-40dc-8ab0-eeae4fed2722.png)** When grouping, count the maximum or the minimum number of activity types in each entry and sort by ascending order. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/5f8091cf-36fb-403a-aa14-d4ce99755312.png) **Max/Min By Activity Type Descending** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/338fcb4d-70d9-4fb7-8c6b-5fa94722a545.png)** When grouping, count the maximum or the minimum number of activity types in each entry and sort by descending order. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/f3e52a52-259b-4755-bdd9-3e2d1d52e793.png) **Ungroup** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/37f6c7a3-5537-43e3-819b-d67c8925dbb0.png)** Move the grouped column back to the table. This means you will be unable to group by a column. This is what the **Request** screen looks like when ungrouped. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/4c7016f6-a98f-4bb3-b2d3-b3bd1f97adb0.png) This is what the **Request** screen looks like when ungrouped. **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/7922d24e-4b53-42f9-b7b5-bd042cf98a8d.png)** **Hide Group Panel** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/3af2f604-1490-445f-8a8a-9f3ee04801e9.png)** Hide the group panel. **Note: When hiding the Group Panel you will be unable to group by column. You can select to show the Group Panel by right-clicking on a column name and selecting Show Group Panel.** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/1d430a65-d56c-4764-8065-1d4b2fdd79b4.png) **Group Interval** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/9dbf315e-6a02-4965-989a-07c6bfb4435a.png)** This is for date columns only and allows a user to group by daily, monthly, or yearly intervals. The below example is grouped on a monthly basis. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/a4487db3-d9c3-47d3-8fe0-4130ebf85a8a.png) **Smart Interval** groups the dates into a different format where the groups are split over a time period of a month and over and a week ahead. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/9975ec0c-0646-48d8-b614-ba8433b82004.png) **Show Column Chooser** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/b87f3ac8-70bc-46cd-b5bb-c99eb19c80cd.png)** The **Column** **Chooser** allows the user to specify which columns to display in the table. This allows you to reduce (or increase) the amount of data displayed in the table so that you can, at a glance, see more relevant information that is of greater use to you. To enable/disable the column, select the checkbox of the relevant column. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/7337c3b8-2c4c-4b40-ae3f-770508901ca6.png) For example, you can specify to show only **Number**, **Status**, **Description**, **Date** **Created**, **Dismantle** **Date**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/37514f86-4852-4cc9-92de-96057eaad5e8.png) Selecting to display these columns will mean only these columns will be displayed in the table. **Note: You can use the Search Column textbox to search for a specific column to find a specific column quickly.** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/f14aefd2-8a2e-42bc-89c7-d38b68c364bb.png)** **Best Fit** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/d685f8db-b661-40b3-a79f-7395400f1079.png)** Size all columns to best fit the content within these columns. This will widen columns with a lot of content, such as the **Description** column. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/e10e67c8-d6cd-4e30-b835-a35d665312db.png) **Filter Editor** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/80876ef8-6e8b-4d9c-9708-f3565d91103a.png)** The **Filter** **Editor** allows the user to filter the table to display specific data. **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/a754807e-cc10-4a94-8699-15001193f7e2.png)** The **Filter** **Editor** uses conditional formulas to select the display data. The conditions for formulas are selected by clicking the **And** button and then the +. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/946e0f77-120e-4fae-8be9-918999e516cd.png) For more information, please visit the [/wiki/spaces/ADH/pages/2323137013](/wiki/spaces/ADH/pages/2323137013) guide.