After time aggregation and after entity aggregation

The following are the list of aggregation types after time and after entity aggregations are applied:

  • Average,
  • AvgSum
  • AvgNull
  • Count
  • Null
  • NullSum
  • NullAvg
  • Sum
  • SumAvg
  • SumNull

SumSum

In this example, SumSum(A/B) gets expanded into esum(tsum(A))/esum(tsum(B)). A and B get individually summed across time, then (still individually) across entity. The final values are then divided, as shown in the following steps.

  1. Counters summed across time:
    • Cell 1 Counter A 80 + 40 = 120
    • Cell 2 Counter A 40 + 20 = 60
    • Cell 1 Counter B 10 + 20 = 30
    • Cell 2 Counter B 2 + 4 = 6
  2. Counters summed across entity:
    • Counter A 120 + 60 = 180
    • Counter B 30 + 6 = 36
  3. The following computation is the after time aggregation and after entity aggregation:
    • 180/36 = 5