Expressions

Aggregation

3min

Use JSONata aggregation to return the results of values to find a maximum, minimum, or average value in an array.
Configuration 
Result
Expression
Maximum
=$max(@ctx.datasources.mydata.array)
Minimum
=$min(@ctx.datasources.mydata.array)
Sum
=$sum(@ctx.datasources.mydata.array)
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.
﻿
﻿Examples and code snippets ﻿
Aggregated expression
﻿
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.
expression.jigx
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)
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)
﻿
﻿

Result	Expression
Maximum	=$max(@ctx.datasources.mydata.array)
Minimum	=$min(@ctx.datasources.mydata.array)
Sum	=$sum(@ctx.datasources.mydata.array)

Arrays

Boolean

Aggregation

Configuration

﻿Examples and code snippets ﻿

Examples and code snippets