--- title: "Activity Grouping" slug: "activity-grouping" updated: 2023-09-12T12:37:16Z published: 2023-09-12T12:37:16Z canonical: "docs.avontus.com/activity-grouping" --- > ## 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. # Activity Grouping It is possible to drag a column from the table to the **Group** **Panel** section to group by that column. To do this, drag the selected column header and place it in between the toolbar and the table. You will then be able to group by that column. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/eac7a152-7acc-4238-af24-a84577290a05.png) When you group by a column, each unique entry in the column will have its own group. Each entry will be given its own group as shown below. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/c6d1803e-dd95-4941-8017-7860861791e0.png) **Note: You can group by two columns by dragging a second column to the column panel.** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/b829a5c8-fb12-48b8-8f43-118ceb1a48ca.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/dff331a9-ce7e-4082-923f-3a59738b6191.png) **Full Expand** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/dbd0ce5e-c692-473b-ba25-acbd3e40e828.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/771805ff-db4a-4375-8af6-066c77cd21cb.png) **Full Collapse** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/75867f8b-49f7-49c5-bf09-bbe16aa94d54.png) Collapse all groups in the table. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/baf76b3a-ac98-41eb-b1e9-dbeb7cf39d01.png) **Sort** **Ascending** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/46a7517c-ea3f-4b90-bf85-03f823de6868.png)** Sort the groups in ascending order alphabetically or numerically. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/7339bc50-f4ca-4cf1-85b9-6ced628d51b9.png) **Sort** **Descending** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/29394f41-ecfd-4245-8848-49b8f0f30f2e.png)** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/e9415826-542d-4041-bc59-e616c5a2e6ef.png)** Sort the groups in descending order, alphabetically or numerically. **Clear** **Sorting** Clear any column sorting currently active. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/3e4f9798-d946-4fe2-9617-efd708180ba4.png) **Clear** **Summary** **Sorting** When sorting by summary (see below) clear any column sorting currently active. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/ea338d14-91f5-4733-bb57-ed6f0f58dd15.png) **Sort by Summary** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/c45e5c6a-9359-41c2-a113-99189ecc0542.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 **Activity** **Type**, you could select to display information from the **Assigned to** column for each group. The summary would then provide an overview of the data pulled from the **Assigned to** column including the number of entries in each group and the minimum and/or maximum status of each group. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/ae6bee55-d35c-4928-82bf-3cb70ca6ea97.png) All this is set up in the **Group Summary Editor** where you can define which column to pull information from and display in the summary. **Group Summary Editor** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/791d1315-af1d-4a4c-a3a9-1558c5e8624e.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 is 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 and minimum status 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/796af9e5-276c-4afd-8810-757016c7c06c.png) **Note: The Max by Status summary options will change depending upon the selected column. For example, selecting Activity in the Group Summary Editor will set the summary option to Max by Activity Type.** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/ee44deea-cc8f-4e4b-9faa-c03984ba2fff.png)** Click **OK** and the table will display the summary of each group detailing the maximum or minimum **Status** of an activity for that group. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/ae6bee55-d35c-4928-82bf-3cb70ca6ea97.png) **Note: You can summarise the average and sum of a column for each group. These columns will be available on numerical columns such as scaffold height and scaffold base elevation.** **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/14a0896d-1d93-405f-83c1-6c7adc26590b.png) The box in the middle lists the columns you selected in the **Items** tab. You can use the arrow buttons to the right to adjust the order in which the summaries are displayed. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/37ad954a-2057-463b-a1f6-f8dcab7173bb.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/df0dc462-5eab-4246-bb34-c92d0631a97d.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/c786c73a-b5f6-465c-8d09-dd580cb391e3.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/24d221ac-b581-4d50-b450-0d0f3dc9dbe8.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/441467b4-c993-46c4-b3a9-0ffff70aabe8.png) Using the settings above will display the row count like so: ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/50d8bd79-0b9e-40ba-86ca-47a45ee689b0.png) **Note: Make sure to include a space at the end of the Prefix and the start of the Suffix.** Enabling the **Show row Count** option and selecting a column in the **Group Summary Editor** will then reveal the following **Sort by Summary** options. **Count by Ascending** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/9b85c798-b540-426e-ba2b-1aec9caf6ee4.png)** When grouping, count the number of entries in a group and sort by ascending order. In the example below, the groups are ordered based on the number of rows in the group. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/9a156ee2-101f-44eb-8259-fdc2f873cbf6.png) **Count by Descending** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/987795c5-74b5-4690-b7ff-35ec78a93101.png)** When grouping, count the number of entries in a group and sort by descending order. In the example below, the groups are ordered based on the number of rows in the group. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/8a90585b-7002-44d5-b30d-7957d192624f.png) **Max by Ascending/Descending** When grouping, this will count the maximum number of each entry of the selected column in a group and sort by ascending order by the status. In this example, we are displaying a summary of the maximum **Status** per group. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/0665e02a-d190-4941-8bac-77f788fd3cbc.png) This will then order the groups alphabetically via the **Status**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/db245ab6-77e4-4d65-b45f-277247747808.png) **Note: This sort by option is available when the Max, Min, Average and Sum settings are enabled in the Group Summary Editor. For more information, see the Group Summary Editor section below.** **Min By Ascending/Descending** When grouping, this will count the minimum number of each entry of the selected column in a group and sort by ascending or descending order. In this example, we are displaying a summary of the minimum **Status** per group. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/6b61e2b2-0fa1-48f4-b431-9667a92c12dd.png) This will then order the groups alphabetically via the **Status**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/8811bf94-a262-407d-b759-adb17a436adc.png) **Ungroup** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/31623eb7-7402-487c-bdb5-6ff73242273c.png)** Move the grouped column back to the table. This is what the **Activity** screen looks like when grouped. **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/707d9407-6562-4c0b-ae91-46f866719105.png)** This is what the **Activity** screen looks like when ungrouped. **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/771805ff-db4a-4375-8af6-066c77cd21cb.png)** **Hide Group Panel** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/f142ca13-5f94-4582-a11d-d210a2377dca.png)** Hide the group panel. Hiding the group panel means you will be unable to group by a column. **Note: When hiding the Group Panel, you can select to show the Group Panel****. Right-click on a column name and select Show Group Panel.** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/bacc2ea9-3b19-4f19-b17b-7bd0f0244e9c.png)** **Group Interval** **(available on date fields only).** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/20364ed6-99e2-489e-9667-429af29610f8.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/b087f16b-a7b4-42c0-b551-b0eafb1a4098.png) **Smart** **Interval** groups the dates into a different format where the groups are split over a time period of a month (or older) and a week ahead. It allows for increased variance in your groups. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/5b725715-d92f-4ba0-8255-c3e1021019fc.png) **Show Column Chooser** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/a1e58dcd-7b7c-40b4-8f9d-8f41cc48e5af.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 on the table so that you can show, at a glance, can see relevant information for yourself. To enable/disable the column, select the checkbox of the relevant column. For example, you can specify to show only the select columns below. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/878f677f-faa0-48ec-88c9-788e4b9e8452.png) Selecting to display these columns will mean only these columns will be displayed in the table. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/c517f852-dda8-4130-b1cc-e550858b6a00.png) **Best Fit** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/30932342-08f8-494e-afe4-c723df89c8b9.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/2de23c26-eddb-491a-8382-e442b085be91.png) **Filter Editor** **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/6318a941-f4fb-42bf-9877-81038ba55371.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/24bc0ad9-7dac-4584-86cf-0a192f44b668.png) For more information, please see [/wiki/spaces/ADH/pages/2323137013](/wiki/spaces/ADH/pages/2323137013)