This functionality is now available to all users. Contact your Customer Success Manager or Account Executive for information.
Numeric aggregation in Warehouse-Native Experimentation Analytics lets you create simple aggregations over existing columns in your data.
A numeric aggregate block calculates a summary of a property or block. The calculation applies an aggregation function to the input property and organizes its results into groups. The result of the numeric aggregate block is a numerical value that may include a grouping attribute if the configuration uses the Group by option.
Example usage
Use a numeric aggregation block to calculate the Total Spend per User by combining transaction amounts for each user.
Configuration
For the numeric aggregation metric, you must choose a measure type and configure the events for that metric type.
The following measures are available:
Conversion Rate
The percentage of actors that did a conversion event. For this measure type, select the events you want to analyze and set the format in which you want to see your results. The format is set to Percentage by default. The other formats available are Decimal, Date, Time, Date-Time, Time Durations, Currency, Units, Hyperlink, and Rich Text.
Average Event Count per Actor
The average number of events each actor performs. Select the events that you want to analyze.
Aggregate over property of an event
Custom aggregate for actors who did at least one of the events. Select an aggregator, set the value, and select the events you want to analyze.
Intervals Engaged
The count of time buckets for each actor in which that actor met the engaged event criteria. You need to configure the Interval and then select the event.
You can also configure property filters within the conversion metric block.
See Aggregation block in the Analytics documentation.
Article is closed for comments.