Group By Entry Property Panel

Create groups according to the value of an entry property. All entries with the same value of the property or same range of property values are assigned to the same group. For boolean properties, two groups are created, one for TRUE values, and one for FALSE values. For string properties, a group is created for each unique string. For real and integer properties, groups are created that span a specified range of property values.

This panel is intended for the creation of multiple groups. To create a single group based on property values, use the Select Entries by Property Values Dialog Box to select the entries, then create a group.

To open this panel, choose Table → Other Entry Actions → Group By Entry Property

  • Features
  • Additional Resources

Group By Entry Property Panel Features

Property text box and button

Choose the property whose values will be used to define the groups. When you click the button, a pane opens for the selection of the property, with the following controls:

Search text box

Filter the contents of the property list so that only the items that match the expression in the text box anywhere in the property name are displayed. You can use the wildcard characters * for zero or more characters and ? for a single character, and square brackets to enclose a range of characters. The filtering is done as soon as you type in the text box. To remove the filter, click the clear button .

Filter button menu

This button opens a menu with sorting and subset items. You can choose sort the list in one of two ways: Alphabetical or Project table order, and you can filter the properties shown in the list to those in the chosen subset. The subsets include the defined property families and two other items, All primary, and Shown (the properties that are shown in the Project Table). If you choose one of the subsets, its name is displayed below the filter text box, with a close button so you can remove the subset filter. In some instances, a filter is preselected when you open the dialog box.

Property list

List of properties for selection. When you choose a property, the selector closes and the property name is shown in the noneditable text box.

When the property is chosen, a set of tools in the settings section is displayed that is appropriate for the type of property (real, integer, boolean, string).

Group prefix text box

Enter the prefix for the group name in this text box. The prefix is optional. The name and value of the property that defines each group is added to the prefix to form the group name. For real and integer properties, the property range is used instead of the property value to construct the group name.

Grouping settings

This section displays text boxes and options to specify the size and range of the bins into which entries are grouped for numeric properties.

For integer and real properties, the entries are sorted into contiguous bins of a specified size, based on the property value. The bin size, the alignment of the bins, and the range of properties considered can be specified in the four text boxes that are displayed:

  • Step Size—Size of the bins used to divide the entries into groups. The bins include the lower end of the range of values but exclude the upper end: thus a bin of size 2.0 for a real property starting at 2.0 would cover the range 2.0 ≤ value < 4.0; for an integer property a bin of size 2 starting at 2 would include the values 2 and 3.

  • Bin floor—Reference value for the lower end of each bin (the bin floor). The lower end of each bin is set to this value plus (or minus) a multiple of the step size. For example, if the reference point is 5 and the step size is 3, there will be bins covering the ranges 2–4, 5–7, 8–10, and so on. If the Use minimum value option is selected, the reference point is the minimum of all values of the property in the entries that are to be grouped.

  • Range minimum—Lower limit for property values to be considered. Entries whose value of the selected property is less than this limit will not be grouped. If the Use minimum value option is selected, the range minimum is the minimum of all values of the property in the entries that are to be grouped.

  • Range maximum—Upper limit for property values to be considered. Entries whose value of the selected property is greater than this limit will not be grouped. If the Use maximum value option is selected, the reference point is the maximum of all values of the property in the entries that are to be grouped.

Define groups within each level of hierarchy option

Define groups only within a given level of the existing group hierarchy: existing groups continue to exist, and the new groups are created within them. If this option is not selected, the new groups supersede the old groups for the entries that are in the old groups.

Group selected entries only option

Select this option to create groups for the selected entries only. This option is selected by default if you open this dialog box from the shortcut menu for the entries, otherwise it is deselected by default.

Reset button

Reset the panel to its default settings. Clears all data from the panel.

Related Topics