Grouping actions

A major part of GridView functionality is the ability to group grid data by columns, or "categories." Within a GridView panel there are a variety of ways to group and ungroup your data.

Grouping

There are three ways to set a grouping in a GridView panel:

    • Drag the column header to the group zone area. Group hierarchy position will be indicated by red arrows. When grouping more than one column, you can drag the header directly to the desired hierarchy position. v16_5_general_flexygrid_GroupActions_1.gif


    • Click the 'Group grid data by selected column' toolbar button  v16_5_general_flexygrid_GroupActions_2.gif  or its corresponding context menu option (found in the 'Grid Tools & Options submenu) as shown below. This will group by the column that is currently in focus.
      v16_5_general_flexygrid_GroupActions_3.gif

      TIP

      When this function is used, the grouped column will remain in memory until another column is selected (the toolbar button will be highlighted as an indication) allowing you to toggle this grouping on and off. This is useful for "testing" a grouping.

    • Use the Ctrl + I key command.


Performing the reverse action on groupings already set will unset the grouping and arrange the grid data accordingly.
When the drag-and-drop method is used, you can return the column header to any position you choose.
v16_5_general_flexygrid_GroupActions_3_1.gif

NOTE

You can also hide the column directly by dragging the column to the trashcan on right-hand side of the group zone  v16_5_general_flexygrid_GroupActions_3_2.gif .


Group Hierarchy

When setting multiple groupings, the order in which the groupings are set in the group zone determines the way your data will be grouped. The group hierarchy is shown visually in the group zone, with the highest-level group being the farthest to the left, and is also reflected in the grid.
v16_5_general_flexygrid_GroupActions_4.gif
As shown in the example above, the group order is as follows: Database File Type, Logical size, and Database Type.


Position in the grouping hierarchy can be set directly upon dragging a column header to the group zone, by dragging column headers already in the group zone to a new position, or by changing the column's Group Level in the Grid Manager.

v16_5_general_flexygrid_GroupActions_5.gif
The screenshot above shows the corresponding Group Level in the Grid Manager.

Unsetting Multiple Groupings

In addition to the simple drag-and-drop method of unsetting single groupings, GridView panels also offer options, and at varying strengths, to unset more than one grouping at the same time:

    • Clicking the 'Ungroup All' toolbar button  v16_5_general_flexygrid_GroupActions_7.gif , its corresponding context menu option (found in the 'Grid Tools & Options' submenu) as shown below, or using Ctrl + shift + G will unset all groupings. v16_5_general_flexygrid_GroupActions_8.gif

    • Clicking the 'Unset all Grouping and Sorting' toolbar button  v16_5_general_flexygrid_GroupActions_9.gif , its corresponding context menu option (found in the 'Grid Tools & Options submenu) as shown below, or using Ctrl + Shift + F6 will unset all groupings as well as all current sorting. See this page for more about sorting.

v16_5_general_flexygrid_GroupActions_10.gif
    • Clicking the 'Restore Grid to its original order' toolbar button  v16_5_general_flexygrid_GroupActions_11.gif , its corresponding context menu option (found in the 'Grid Tools & Options submenu) as shown below, or using Ctrl + Shift + F6 will unset all groupings, all current sorting and filters, as well as resetting your grid position to the top. See this page for more about sorting. See this page for more about filters.


v16_5_general_flexygrid_GroupActions_12.gif


Group Totals

Beyond the ability to arrange your grid data by category, you can bring additional clarity to your data set by activating the group total function for the categories that you choose.

This can be done by selecting the group total type in the 'Group Totals' dropdown menu in the Grid Manager.
v16_5_general_flexygrid_GroupActions_13.gif

Once a total type is selected, it will be displayed on the category header within the column it is set on. You may change the column position without affecting the calculation.

The available options for setting a Group Total will vary depending on the type and status of the column. The following table shows what choices are available for the different column types.

Group Total Options Available for each Column Type:

Text

Number

Time/Date

Checkbox

Count

Sum

Minimum

Count Checked Only

Count but Exclude Empty Cells

Average

Maximum

Count Unchecked Only

https://www2.ytria.com/icons/ecblank.gif

Minimum

Delta

Count

https://www2.ytria.com/icons/ecblank.gif

Maximum

Count

https://www2.ytria.com/icons/ecblank.gif
https://www2.ytria.com/icons/ecblank.gif

Delta

https://www2.ytria.com/icons/ecblank.gif
https://www2.ytria.com/icons/ecblank.gif
https://www2.ytria.com/icons/ecblank.gif

Count

https://www2.ytria.com/icons/ecblank.gif
https://www2.ytria.com/icons/ecblank.gif
https://www2.ytria.com/icons/ecblank.gif

Count but Exclude Empty Cells

https://www2.ytria.com/icons/ecblank.gif
https://www2.ytria.com/icons/ecblank.gif


The various Group Total selections function as follows:

  • Count: This will calculate the amount of entries within the category.

  • Count but Exclude Empty Cells: This will calculate the amount of entries within the category minus the number of cells that are empty either because their information is not yet loaded or the value doesn't exist.

  • Sum: This calculates the sum of the cells within a given category.

  • Average: This calculates the mean value for all the cells within the category.

  • Minimum: This will display the category's minimum cell value.

  • Maximum: This will display the category's maximum cell value.

  • Delta: This will calculate the difference between the minimum and maximum cell values.

  • Count Unchecked Only: This count only considers "Unchecked" values.

  • Count Checked Only: This count only considers "Checked" values.