Grouping Jobs Lists

In Jobs lists, you can Group information by one or more columns, for example, Client Group, Client, Category, and Job State.

Grouping is currently available in the Jobs lists, including Home - My Jobs and Client - Jobs. Only certain columns can be used for Grouping. For example, the Jobs lists can only be Grouped by Client Group, Client, Name, State, Category, Cabinet, Partner, Manager, Created By or Modified By.

Grouping a List

In a list that allows Grouping, when you expand the Columns tab on the left-hand side it displays the Row Groups and the Values sections.

2193_New_Lists_Columns_with_Groups.gif

To Group the list by a column, drag the header of the relevant column to the Row Groups (click and hold on the '=' sign to drag the column name).

Tip: You can group by Custom Fields with a Type of Checkbox, Drop-down, Text and User. Jobs with no selection for that Custom Field will not be grouped. 

The following is an example of Grouping the list by State.

2195_New_Lists_Dragging_State_Column_for_Groups.gif

You can also drag a column from the list in the Columns tab into the Row Groups by dragging it with the = icon in the Columns tab list.

2527_Jobs_List_Drag_Column_to_Row_Groups_with_Equals.gif

Dragging a Column that is Not Relevant for Grouping

If you try to drag a column that is not relevant for Grouping to the Row Groups (such as Name or ID) it cannot be dropped and shows with the icon to indicate it is not available, as in the following example.

2194_New_Lists_Invalid_Column_for_Groups.gif

When a Column has been selected as a Group

  • The list is Grouped by the column and this shows in the list with the heading of Group.
  • The column that has been added as a Group displays at the top of the columns.
  • The column is removed from the main list.

2196_New_Lists_Dragging_State_Column_for_Groups.gif

You can sort the Group by clicking the column heading in the same way as other columns in the list.

When saving a view that has the Group sorted, the saved View re-displays with the saved sort order.

2197_New_Lists_Sort_Group.gif

To expand or collapse a Group, click the Expand or Collapse icon on the left-hand side of the value.

2198_New_Lists_Expand_Collapse_Group.gif

You can also right-click over the list to display the pop-up menu and select Expand All or Collapse All to expand or collapse all the Groups.

2199_New_Lists_Expand_All_Collapse_All_Group.gif

When saving a View with grouping, the saved Views will always re-display with collapsed values. 

Selecting Items in a Group

When a list is grouped, the Select 50 and Select All options are not available. You can click the select checkbox next to a Group title to select all the items in that group. You can tick the Group when it is collapsed or expanded.

Note: Users are currently prevented from unselecting rows when the list has been grouped. To remove the selection, click Cancel at the top of the screen. Our engineers are working on implementing a solution to the issue as soon as possible.

2544_Jobs_List_Grouped_Select_a_Group.gif

Adding more than one Group

You can add more than one column for the Groups in the same way by dragging the column heading to the Row Groups. The following example shows Client added as a second Group.
This displays in the same sort order in which it was shown in the list.

2209_New_Lists_Add_Second_Group.gif

Removing a Group

To remove a Group, click the x next to it either at the top of the Columns or in the Row Groups.

Note: When a Group is removed, the columns will be reinserted as new columns at the end of the view on the right-hand side.

2210_New_Lists_Remove_a_Group.gif

Exporting a List that is Grouped

In Jobs lists, you can export the list as Excel using the Excel Report function from the View Tools. Refer to Exporting Lists

When a list is Grouped, the Grouping is reflected in the exported file.

Important Note: The Client Group, Client and Name (such as the Job Name) in the exported Excel file are hyperlinks and these may only display after clicking Enable Editing in Excel.

If grouping by a Custom Field with a type of "User" the User ID will be displayed in the Exported File

The following is an example of the exported Excel spreadsheet with two Groupings (State and Client) after clicking Enable Editing in Excel.

2515_Excel_Report_With_Grouping_After_Enable_Editing_in_Excel.gif

When Grouping has been applied, you cannot export the list as a .csv file and the following message displays.

2265_Export_Grouped_List_cannot_export_CSV.gif

Calculations

At the bottom of the Columns tab is the area where you can add Values which can be used to include calculations for any numeric columns in the list. You can only apply Values to a numeric column.

To add a column, drag the header of the relevant column to the Values. You can also drag a column from the list in the Columns tab into the Values by dragging it with the = icon in the Columns tab list.

The following is an example of dragging the Estimated column to the Values.

2516_Jobs_List_Adding_Values.gif

You can include additional columns for the calculations and they initially show as calculating a "sum".

2216_New_Lists_Aggregate_Values.gif

The calculations display at the bottom of the list on the right-hand side.

2272_New_Lists_Calculations.gif

You can remove any of the calculation values by clicking the x.

2273_New_Lists_Remove_a_Calculation.gif

You can change what is calculated for a column by clicking on it and selecting from the available calculations such as "avg" for average, "min" for minimum or "max" for maximum.

2274_New_Lists_Change_Calculation.gif

If Calculations have been added to the list that you are exporting (using the Values at the bottom of the Columns tab) these are included in the export.

 

Was this article helpful?
1 out of 1 found this helpful