User Tools

Site Tools


transformations:aggregate

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
transformations:aggregate [2015/05/01 12:49]
dmitry
transformations:aggregate [2020/02/10 16:23] (current)
dmitry
Line 10: Line 10:
   * Min   * Min
   * Max   * Max
 +  * Any
  
 EXAMPLE EXAMPLE
Line 41: Line 42:
 | Amazon  |  South America  |  6400  | | Amazon  |  South America  |  6400  |
  
 +=== Notes ===
 +
 +The "Any" aggregation picks only 1 arbitrary (random) value from a group of values and discards the rest.
 +
 +The "Any" aggregation is typically used for non-numeric values, where all values in a group are known to be the same. E.g. "Any" applied to "ABC", "ABC", "ABC" will return "ABC".
 +
 +=== See also ===
 +  * [[transformations:runningtotal|Running total]]
 +  * [[transformations:subtotal|Total / subtotals]]
 +  * [[transformations:breakdown|Break down]]
transformations/aggregate.1430484574.txt.gz · Last modified: 2015/05/01 12:49 by dmitry