Differences

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

--- transformations:aggregate [2025/01/09 21:37] – revise to 2025 format craigt
+++ transformations:aggregate [2025/01/10 11:12] (current) – craigt
@@ Line 10: / Line 10: @@
 =====Use cases=====
 Available aggregations:
-  * Sum
+  * Sum: generates the total of values.
-  * Count
+  * Count: generates the count of values.
-  * Count only distinct values
+  * Count only distinct values: generates the count of unique values.
-  * Average
+  * Average: generates the average of values.
-  * Min
+  * Min: generates the minimum of all values.
-  * Max
+  * Max: generates the maximum of all values.
-  * Any
+  * Any: returns the first value in the selected column.
-  * Concatenate
+  * Concatenate: combines all values into a single string, delimited by the selected character.
 \\
@@ Line 42: / Line 42: @@
 ===Before (source table)===
-The longest rivers in the world
 ^ River  ^ Length(km)  ^ Continent  ^
 | Amazon  |  6400|South America  |
@@ Line 52: / Line 50: @@
 | Paraná  |  4880|South America  |
-===After (result) table===
+===After (result table)===
-^Continent  ^Max of Length(km)  ^
+^Continent  ^Length(km)  ^
 |**Asia**  |  **6300**|
 |**North America**  |  **6275**|
@@ Line 83: / Line 81: @@
   * [[transformations:Rule|Rule]]
   * [[transformations:slidingaggregation|Sliding aggregation]]