Skip to main content
Community

 

 

 

Template:OutSystems/Documentation_KB/Breadcrumb_New_Layout
Documentation
OutSystems 11
Developing an Application
Use Data
Query Data
Calculate Values from Grouped Data
Query Data

 

 

Template:OutSystems/OSLanguageSwitcher
Language:
English日本語

 

 

 

OutSystems

Calculate Values from Grouped Data

  1. Last updated
  2. Save as PDF
Template:OutSystems/Documentation_KB/ContentCollaboration
  • Edit
    Collaborate with us
    Edit this page on GitHub

    • Putting data into groups to calculate aggregated values allows you to extract more information from your data sets. In OutSystems, you can use aggregate functions to calculate values based on groups of identical data.

    Fetch the data in an aggregate and do the following:

    1. In the attribute with identical data, use the Aggregate Menu menu and select Group by <attribute>.
    2. In the attribute to calculate, use the Aggregate Menu menu and select an aggregate function such as Count.

    Once you group or use aggregate functions on attributes, those attributes become the only output of the aggregate.

    Example

    In the GoOutWeb application to find, review, and rate places, you want to show the average rating of places to help to take a decision. Consider that you already have an Aggregate fetching all the reviews of a place from the database. Open the aggregate and do the following:

    1. On the Place.Id attribute, open the Aggregate Menu menu and choose Group By Id.

    2. On the Review.Rate attribute, open the Aggregate Menu menu and choose Average.

    3. Use the calculated values to display the average rating for each place on the screen.