The summarize operator produces a table that aggregates the content of the dataset. The input rows are arranged into groups having the same values as the by expressions. To find the average price of the paint for each customer, use the query below:
Loading APL Editor...
Here are a few other examples to try:
summarize Min = min(date)
summarize count() by customer_name
To learn more, see the summarize operator docs.