Global Aggregate Functions

Functions for aggregating values across all events in the entire dataset.

Understanding Global Aggregates

While case aggregates operate within a single case, global aggregates calculate across all events in the dataset. This enables:

• Calculating overall totals and averages
• Comparing individual events or cases to global benchmarks
• Computing percentages of total

Common Patterns

• Overall Statistics:

  allSum(Revenue)           // Total revenue
  allAvg(ProcessingTime)    // Average processing time
  allCount()                // Total number of events

• Percentage of Total:

  caseSum(Amount) / allSum(Amount) * 100   // This case as % of total
  Amount / allSum(Amount) * 100            // This event as % of total

• Compare to Average:

  Duration - allAvg(Duration)              // Difference from average
  Duration / allAvg(Duration)              // Ratio to average

• Filtered Global Aggregates: Calculate aggregates for a subset of the data:

  allSumIf(Amount, Region == "Europe")     // European total
  allAvgIf(Duration, Priority == "High")   // High-priority average
  allCountIf(Status == "Completed")        // Completed count

• Identify Outliers:

  if(Duration > allAvg(Duration) + 2 * allStdDev(Duration), 
     "Outlier", "Normal")

Statistical Functions

Statistical functions for analyzing the distribution of values across all events.

• Identify Performance Tiers:

  Percentiles are passed as fractions from 0 to 1 (0.25 = 25th percentile):

  if(Duration < allPercentile(Duration, 0.25), "Fast",
     if(Duration < allPercentile(Duration, 0.75), "Normal", "Slow")
  )

• Find Outliers: Values beyond 2 standard deviations from the mean:

  if(abs(Amount - allAvg(Amount)) > 2 * sqrt(allVariance(Amount)),
     "Outlier", "Normal")

• Compare to Benchmarks:

  Duration > allPercentile(Duration, 0.9)   // Is this in the top 10% (slowest)?

Related topics

• Expressions Overview: all expression functions.