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...

No query result to show, please click the 'run query' button above!

Here are a few other examples to try:

  • summarize Min = min(date)
  • summarize count() by customer_name
  • summarize dcount(paint)

To learn more, see the summarize operator docs.

Was this page helpful?