Applying an Aggregate Function to a Field


Concept


Steps:

  1. Begin by navigating to the Fields page.

     

    Click the Reporting Tools link.

    Step 1
  2. Click the Query Manager link.

    Step 2
  3. Click the Search button.

    Step 3
  4. Click an entry in the Edit column.

    Step 4
  5. Use the Fields page to:

    •  View how fields are selected for output.

    •  View the properties of each field.

    •  Change headings, order-by numbers, and aggregate values.

    Step 5
  6. In this example, you will edit aggregate function for the Attribute Name row.

     

    Click the Edit button.

    Step 6
  7. In this example, select the count aggregate.

     

    Click the Count option.

    Step 7
  8. Click the OK button.

    Step 8
  9. The Attribute Name row now has value of Count in the Agg column.

    Step 9
  10. Click the Save button.

    Step 10

You have successfully reviewed how to apply an aggregate function to a field.

Table of Contents  Start Topic