Categorize report data with aggregations

Setting an Aggregation on a field will group like rows together based on other columns.  Aggregation options are available for Date, Money, Number, and ID fields. By default, no aggregation is selected for any field types.  If an Aggregation option is selected for a field, you will find the type of aggregation in parenthesis next to the field.

Follow the steps below to change the aggregation for each field:

  1. Select Reports  > Builder.

  2. Use the Show All button to view all custom reports. Or use the Search field to further drill down your search. 

  3. Select the Report from the list. 

  4. Right-click on the field after it has been dragged onto the Columns area and select the desired option from the Aggregation menu.

    1. Date Field Aggregation:

      1. No Aggregation: Displays all of the dates the patient has.

      2. Maximum: Displays the most recent date.

        If aggregation is set to Maximum for the Claim From Date field, the report will only display the most recent Claim From Date.

      3. Minimum: Displays the earliest date.

        If aggregation is set to Minimum for the Claim From Date, the report will only display the earliest Claim From Date.

    2. Money Field Aggregation

      1. No Aggregation: Displays all of the amounts. 

      2. Sum: Displays the summation (total) of the values.

        If aggregation is set to Sum for the Charge Amount field, the report will display  the Average for the only Charge Amount column.

      3. Average: Displays the average of the values.

        If aggregation is set to Average for the Charge Amount field, the report will only display the Average for the only Charge Amount column. 

      4. Maximum: Displays the largest value. 

        If aggregation is set to Maximum for the Charge Amount field, the report will display the largest charge amount for each claim. 

      5. Minimum: Displays the smallest value.

        If aggregation is set to Minimum for the Charge Amount field, the report will display the smallest charge amount for each claim.

        Check Your Understanding:

        Notice the two like rows have been grouped together based on the non-aggregated fields and the Charge Amount is now reporting the average value for the grouped like rows. The last row on the report was not grouped with the first two rows because the Claim ID value was different (i.e. this charge was associated with a separate claim).

    3. Number Field Aggregation

      1. No Aggregation: Displays all of the values. 

      2. Sum: Displays the summation (total) of the values.

        If aggregation is set to Sum for the Charge Units field the report will only display the sum value for the Charge Units. 

      3. Average: Displays the average of the values.

        If aggregation is set to Average for the Charge Units field, the report will display the average charge units for each Claim ID.

      4. Count All: Displays the count of all occurrences of the value.

        If aggregation is set to Count All for the Charge Units field, the report will display each occurrence for within a claim.

      5. Count Unique: Displays the count of all unique occurrences of the value.

        If aggregation is set to Count Unique for the Charge Units field, the report will display each unique occurrence for within a claim.

      6. Maximum: Displays the largest value.

        If aggregation is set to Maximum for the Charge Units field, the report will only display the largest value for the Charge Units.

      7. MinimumDisplays the smallest value.

        If aggregation is set to Minimum for the Charge Units field, the report will only display the smallest value for the Charge Units.

        Check Your Understanding: 

        Notice that the two like rows have been grouped together based on the non-aggregated fields and the Charge Units is now reporting the summed value for the grouped like rows. The last row on the report was not grouped with the first two rows because the claim ID value was different (i.e. this charge was associated with a separate claim). The Charge Units field now represents the total number of units billed on the claim regardless of the number of line items.

    4.  ID Field Aggregation

      1. No Aggregation: Displays each occurrence of the value.

      2. Count All: Displays the count of all occurrences of the value.

        If aggregation is set to Count All for the Charge From Date field, the report will display each Charge ID within each claim.

      3. Count Unique: Displays the count of all unique occurrences of the value.

        If aggregation is set to Count Unique for the Charge From Date field, the report will only display the total count of the Charge ID(s). 

        Check Your Understanding:

        Notice that the two like rows have been grouped together based on the non-aggregated fields and the Charge ID is now reporting a count of the unique values in the Claim ID field for the grouped like rows. The last row was not grouped with the first two rows because the Claim From Date value was different. This is because the charge was associated with a separate claim. The Charge ID field now represents the total count of unique charges (or line items) for each claim.