Work with the details grid
- Last UpdatedApr 22, 2022
- 4 minute read
The details grid has controls that allow you to maximize, group, sort, and filter the grid content and adjust the column widths.
Maximize
To maximize the grid to the full size of the browser window
-
Select the Full Screen icon at the upper right of the grid.

To restore the grid size
-
Select the Restore icon.

Group
For certain data types, such as reasons and OEE data properties, you can group the rows of the grid by the data type of one or more columns.
To group by a column
-
Select and drop the column heading on the Group area.


If a column's grouping chip does not appear when selecting and dropping it, grouping by that column is not supported.
To create multiple group levels
-
Select and drop additional column headings on the Group area.


Each group includes summary information for that grouping. The summary information can be based on equipment availability or utilization event duration:
-
With Availability selected, the group header includes the equipment total runtime, total downtime, and percent availability based on the events in that group.
-
With Event Duration selected, the group header includes the event count, total duration, and average duration for events in that group.
To set how the group data is summarized
-
Select Availability or Event Duration.

To change the group level hierarchies
-
Select and drop the group chip to a new position in the Group area.


The group level is ordered from left to right in the Group area.
To remove a grouping
-
Select the X icon on the group's chip.

Sort
To sort by a column
-
Select the column heading.

An arrow to the right of the column heading indicates the sort order. The initial order is ascending.

To toggle the sort order to descending
-
Select the column heading again.
To toggle the sort order off
-
With the column in descending order, select the column heading again.
Filter
You can filter the data in the grid by one or more columns that have the
icon to the right of their heading.
To filter on the data in a column
-
Select
, set the filter criteria, and select FILTER.
Depending on the data type in the column, filter criteria can be set either by selecting check boxes:

Or by entering text strings that must be matched:

For a long list of check box filters, you can find filters of interest by entering any portion of the filter check box label in the Filter By field.

For text-string filters, you can enter one or two text strings.
When using two text strings:
-
To require that both text strings be matched, select the AND operator.
-
To allow either text string to be matched, select the OR operator.
For the text strings themselves, the list above the text string field provides several ways of how the string will be interpreted as filter criteria:

To clear the filter
-
Select
and then select CLEAR.
Column Width
-
Hover the pointer between the column headings until the border between them appears, then select and drag to change the column width.