Reviewing Aggregation Options

You can use Aggregations to convert the usage data collected by your Meters into numerical measures. You can then use these Aggregations to price your product Plans and apply usage-based pricing to your products and services. You might also want to aggregate raw data measures for other purposes, such as to feed into analytical or business performance tools.

This topic explains the configuration options available for Aggregations.

Configuring Aggregations

When you create an Aggregation and have entered a Name and Code you must define several key attributes to ensure the resultant Aggregation value precisely suits your pricing or other requirements:

  • Meter. Each Aggregation is a child of a Meter, so you must first select the Meter you want to use as the source of raw usage data for your Aggregation.

  • Target Field. When you select a Meter, you can then select a Data Field or Derived Field on the Meter as the basis for your Aggregation.

  • Aggregation. This defines the method by which a numerical measurement is determined on the basis of the usage data collected by the Target Field. The options for how the Aggregation gives a unit value based on the Target Field depends on the Category configured for the selected Target Field:

    • Sum. Adds the values. Can be applied to a Measure, Income, or Cost Target Field.

    • Minimum. Uses the minimum value. Can be applied to a Measure, Income, or Cost Target Field.

    • Maximum. Uses the maximum value. Can be applied to a Measure, Income, or Cost Target Field.

    • Count. Counts the number of values. Can be applied to a Measure, Income, Cost, Who, What, Where, or Other Target Field.

    • Latest. Uses the most recent value. Can be applied to a Measure, Income, or Cost Target Field.

    • Mean. Uses the arithmetic mean of the values. Can be applied to a Measure, Income, or Cost Target Field.

    • Unique. Uses unique values and returns a count of the number of unique values. Can be applied to a Metadata Target Field.

  • Unit. The Unit you enter here is a label that will be used for billing to indicate to your customers what they are being charged for. For example, suppose you charge your end customers based on a measure of the volume of data streamed over time, such as kilobytes per second. You can enter KiBy/s as the unit for billing purposes. 

  • Rounding. Used in combination with Quantity per unit. Rounds the number of units after the Quantity per unit has been applied:

    • None

    • Down

    • Up

    • Nearest. Rounds up to the nearest half: 5.1 is rounded to 5; 5.5 is rounded to 6.

  • Quantity per unit. Defines how much of a quantity equates to 1 unit to be used when setting the price per unit for billing purposes. For example, suppose you are charging in kilobytes per second (KiBy/s) and want to charge $0.25 per 500 KiBy/s. When you come to price a Plan using the Aggregation, you can configure the price per unit to be $0.25 and enter 500 here for Quantity per unit. Note that if you set Quantity per unit to a value other than one, you would typically set Rounding to Up. For the current example, suppose your customer on average used 48,900 KiBy/s during the billing period, the billing charge would then be 48,900 / 500 = 97.8 rounded up to 98 * 0.25 = $2.45.

  • Default Value. Optional field - enter a default value to be used for the Aggregation if no usage-data is available from the selected Meter Target field. Set to 0, if you expect to reference the Aggregation in a Compound Aggregation. This ensures that any null values are passed in correctly to the Compound Aggregation calculation with a value = 0.

Segmented Aggregations

If you've set up non-numeric fields on the selected target Meter, you can configure a segmented Aggregation using the Segments panel. See Segmented Aggregations.

Custom Fields

You can define Custom Fields when creating an Aggregation or edit the Aggregation at a later date to do this. Any Custom Fields you create for an Aggregation override those you've created for Aggregations at the Organizational level. We strongly recommend reviewing Working with Custom Fields before you create and use Custom Fields.

Important! Aggregation Custom Fields not supported for calculations. Creating Custom Fields for Aggregations is intended to support financial reporting use cases. Although you can define Custom Fields at both the Organizational level and individual Aggregation level, they are not supported for use in Derived Field and Compound Aggregation calculations.

Next: Creating Aggregations