# Aggregation

Use JSONata aggregation to return the results of values to find a maximum, minimum, or average value in an array.

## Configuration

<table><thead><tr><th width="131.09765625">Result</th><th>Expression</th></tr></thead><tbody><tr><td>Maximum</td><td><code>=$max(@ctx.datasources.mydata.array)</code></td></tr><tr><td>Minimum</td><td><code>=$min(@ctx.datasources.mydata.array)</code></td></tr><tr><td>Sum</td><td><code>=$sum(@ctx.datasources.mydata.array)</code></td></tr></tbody></table>

{% hint style="warning" %}
&#x20;Be careful when using complex expressions, such as expressions that iterate one datasource across another, as your solution performance could become slower. To avoid this, try to use the datasource queries to get the desired result rather than an expression.
{% endhint %}

## Examples and code snippets

{% columns %}
{% column %}

<figure><img src="https://1414514342-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHcPzbms3kZejTmFd500V%2Fuploads%2FR4hWA2yMEzNXuBSJQjB6%2Fepx-aggregation.png?alt=media&#x26;token=545afd2c-e2d6-48f6-98d2-2d01a44d7a87" alt="Aggregated expression" width="188"><figcaption><p>Aggregated expression</p></figcaption></figure>
{% endcolumn %}

{% column %}
In this example static data is agregated in a `component.enity` to show the result in the entity field.

See the full example code sample in [GitHub](https://github.com/jigx-com/jigx-samples/blob/main/quickstart/jigx-samples/jigs/guide-expressions/static-data/expression.jigx).
{% endcolumn %}
{% endcolumns %}

{% code title="expression.jigx" %}

```yaml
datasources:
  mydata: 
    type: datasource.static
    options:
      data:
        - name: Jane Stevens
          title: Doctor
          email: jane@first.com
          number: 0.64734
          number2: 12
          color: blue
          time: '2021-11-07T15:07:54.972Z'
          array: [5,1,2,3,7,9]

children:
  - type: component.entity
    options:
      children:
        - type: component.entity-field
          options:
            label: Max
            value: =$max(@ctx.datasources.mydata.array)
        - type: component.entity-field
          options:
            label: Min
            value: =$min(@ctx.datasources.mydata.array)
        - type: component.entity-field
          options:
            label: Sum
            value: =$sum(@ctx.datasources.mydata.array)
```

{% endcode %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.jigx.com/examples/readme/expressions/aggregation.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.