--- title: "Aggregate Query Data" slug: "aggregate-query-data" description: "Learn how to aggregate query data in Utility Billing using Avg, Max, Min, and Sum metrics to summarize your column results." updated: 2026-08-28T18:27:00Z published: 2026-08-28T18:27:00Z canonical: "www.civicplus.help/aggregate-query-data" --- > ## Documentation Index > Fetch the complete documentation index at: https://www.civicplus.help/llms.txt > Use this file to discover all available pages before exploring further. # Aggregate Query Data > [!WARNING] > Note: > > Some queries cannot be aggregated 1. [View a query record](/utility-billing/docs/view-query-records) 2. Click the **dropdown** to the right of the Sigma Greek letter ![Totals button.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Totals%20Button%20-%20UB.png?sv=2026-02-06&spr=https&st=2026-11-17T03%3A54%3A43Z&se=2026-11-17T04%3A54%3A43Z&sr=b&sp=r&sig=C7lXcPtCFN1M%2Fpu983vMXr%2FCOmAhenTZsi0Uuzc76dI%3D) 3. Select an aggregation metric ![Totals options.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Totals%20Options%20-%20UB.png?sv=2026-02-06&spr=https&st=2026-11-17T03%3A54%3A43Z&se=2026-11-17T04%3A54%3A43Z&sr=b&sp=r&sig=WWEcTPNRdjNK7GRUx1RTTK%2BV9MJ3x8KKaIzxzY%2F2UEw%3D) - **Avg**: Show the average of each applicable column - **Max**: Show the largest value in each applicable column - **Min**: Show the smallest value in each applicable column - **Sum**: Show the total of all values in each applicable column - **None**: Show no aggregated data 4. View results below the table