Summarize

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:

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.