Aggregates

Xano's powerful aggregation capabilities allow you to perform advanced data analysis and retrieve meaningful insights from your database without writing a single line of code. In this step-by-step guide, we'll explore how to leverage Xano's intuitive "Query All Records" function to perform various aggregations on your data.

Step 1: Navigate to Your API Endpoint

First, open your Xano project and navigate to the API endpoint where you want to perform the aggregation. In this example, we'll use the "MLB Players" database table, which contains 1,034 records.

Step 2: Select "Query All Records"

In your API endpoint, locate the "Function Stack" panel and select the "Database Request" > "Query All Records" function. Then, choose the database table you want to query (in our case, "MLB Players").

Step 3: Set the Return Type to "Aggregate"

Next, switch to the "Output" tab and change the return type to "Aggregate." This will reveal additional options for grouping, aggregating, and sorting your data.

Step 4: Group Your Data

To group your data, select the field(s) you want to group by from the "Group By" dropdown. For instance, if you want to group the players by their teams, select the "team" field.

Step 5: Aggregate Your Data

After grouping your data, you can choose the aggregation function you want to apply. Xano offers a range of aggregators, including average, count, max, median, min, sum, and more. Let's say you want to find the average age of players for each team. Select the "age" field and choose the "Average" aggregator, then rename the field to "Average Age."

Step 6: Sort Your Data (Optional)

If you want to sort your aggregated data, use the "Sort By" option. For example, to see which team has the youngest players on average, sort by the "Average Age" field in ascending order.

Step 7: Run Your Query

Save your changes and run the API endpoint. Xano will perform the aggregation based on your specified parameters, and you'll see the aggregated results in the response.

Advanced Aggregations

Xano's aggregation capabilities go beyond simple grouping and aggregating. You can perform more complex aggregations by adding multiple group-by fields, multiple aggregators, and additional sorting rules. For instance, you could group players by team and position, then calculate the average age, maximum salary, and count for each combination.

Aggregations with Add-Ons

Xano's add-ons can also return aggregated data. If you're querying data from an add-on and need to perform aggregations on the related data, you can use the same aggregation engine within the add-on's query.

By leveraging Xano's intuitive aggregation tools, you can quickly uncover valuable insights from your data, regardless of your technical expertise. Whether you're analyzing sales transactions, building reports, or exploring financial data, Xano's no-code approach streamlines the process, empowering you to make data-driven decisions with ease.