Aggregations & Cross Tabulations

Parent Previous Next

Create Aggregation

An 'aggregation' is a record that acts as a root or pivot point for a group of other records that share a common trait that is not part of their attributes. For example, you may wish to aggregate all records that have a connection to World War II but don't have any particular trait that indicate this.

The Aggregation record itself is a record of type Aggregation that has a name and description, that these records can point to.

Aggregation records also allow you to define various strings for queries, layout and filters.

To create an Aggregation

Note. Ensure the Aggregation record type is enabled in Record Types screen:

  1. Create a new record of type Aggregation:

  1. Complete the record details and save it.

  1. The aggregation is now available by selecting the Aggregations link on the Navigation Pane.

To add a record to an aggregation

  1. Search and select the records you wish to add.
  2. Select Selected | Relate To:

  1. Select a Relationship Type of IsPArtOf.
  2. Select a record type of Aggregation.
  3. Click on the Aggregation you wish to link to.

For example:

  1. Click Add Relationship.

You can see the records relate to this aggregation in the Related (or Relationship Tab) section of the record:

Cross-Tabulation (Not fully implemented.)

A cross-tabulation is a way of calculating counts of aggregations sorted by category.

Imagine value (that we set to Var 1) is the value of a colour system that has the entire spectrum of colours encoded as numbers. Numbers that are close to each other represent colours that are close to each other. Imagine that the type field (that we set to Var 2) indicates what material the potsherd is made out of. We can use a cross-tabulation to generate instant categories by splitting up the entire range of entered values into 10 buckets, or deciles. This allows us to see, for example, that the range 100128 ~ 198607 contains the most examples in our database.

To run a simple cross-tabulation

  1. Search for the records you wish to analysis (e.g. use the Database Summary dialog).
  2. Select Database | Analyse | Crosstabs. The Crosstabs dialog displays.
  3. In the Record Type field, select a record type you wish to analysis:

  1. For var 1 (rows) choose your first variable (this will simulate a tabulation by that variable).
  2. For var 2 (cols) choose the second variable (this splits the range of values into 10 'buckets' and counting how many values appear in each 'bucket' by type.
  3. Var3 is an optional variable that breaks the analysis further, into 'pages'.
  4. In the lower box, define how you wish the data to be analysed.
  5. When ready, click the Run button at the bottom of the page

This produces a tabulation of the data in the selected fields.

Note. Save functionality is not yet implemented.

Created with the Personal Edition of HelpNDoc: Free CHM Help documentation generator