How to calculate Average from fields from a json datasource



I want to calculate or get the average of the values return by a json datasource, so like if I will access 1 item from my json it will look like @/items/fields/values/value I do have like 1000 items on that json data.

Can anyone please help me do the calculation, I appreciate any help.



1 comment

  • 0
    Support Team

    Hi Carson,

    Thanks for reaching out to Klipfolio Support!

    You can make use of the Average function to get the average of the values.

    You can use something like Average(@/items/fields/values/*)

    Hope this helps!

    Kind Regards,

    Pratyusa Ray





Please sign in to leave a comment.