View a markdown version of this page

addtotals - Amazon CloudWatch Logs
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

addtotals

Use addtotals to compute row totals and column totals for numeric fields. Row totals are computed per-chunk. Column totals (col=true) are computed post-merge for correctness across distributed chunks. You can use custom field selection, a custom fieldname, and row=false to disable row totals.

Syntax

| addtotals [fieldname=Name] [row=bool] [col=bool] [field1, field2, ...]

  • fieldname=Name — Sets the name of the row total column. The default is Total.

  • row=bool — Enable or disable row totals. The default is true.

  • col=bool — Enable or disable column totals, which adds a summary row at the bottom. The default is false.

  • field1, field2, ... — Optional list of specific fields to sum. If omitted, all numeric fields are summed.

Examples

# Row totals (default) - adds a Total column summing all numeric fields
fields a, b
| addtotals
# Sum only specific fields
fields price, tax, qty
| addtotals price, tax
# Custom total column name
fields val
| addtotals fieldname=RowSum
# Column totals - adds a Summary row at the bottom
fields x
| addtotals col=true x