Adding a Grouping by Values

It is possible to group the data and then apply an aggregate function to get a subset of data as required. This can be done either in conjunction with a filter or without depending on the need.

Follow the steps in the Adding a Filter section, then follow the below steps;

• If required, create a Filter Group, else skip this step.
• Select the Grouping tab.
  
• Select the group that the data will be grouped by (Note that it is not possible to group records on the source table).In the example below, a list of Liquid Limit Records will be displayed, grouped by the Sample that the test was recorded against.
  
• Ensure that the Group By Values option is selected.
  
• Select the Add button to add a new grouping.
  
• Give the Group a Name by entering a value into the Name column. In this example, the minimum Liquid Limit value will be shown (filtered to only U Samples).
  
• Select the field from the source table that the data is to be taken from.
  
• Select the Aggregate function that the data will be grouped by as follows;
  • Average – Average value of the data.
  • Count – Number of records
  • First – Initial value from the list of records
  • Join – Lists all of the records which match the criteria and will display them in the order given in the above step.
  • Join Distinct – Functions the same way as Join but only shows a record if it has not appeared before. Therefore, if there were to records that were of a value of 2, then 2 would only be shown once.
  • Last – Final value from the list of records
  • Maximum – Determines the maximum numeric value
  • Minimum – Determines the lowest numeric value
  • Order Ascending – Records are shown in an ascending order
  • Order Descending – Records are shown in a descending order
  • Sum – Calculates the sum of the values in a list of records
    
• Select OK to close the dialogue.