Average function of JSON data

Hi all! How can I display by counter the average age of people? I have an age Json data, but can not get the average values of this.

Which data source are you querying? It probably has an AVERAGE or AVG function you can use.

The fact is that AVG function doesn’t work with json data types

That’s not unusual. In these cases you can use JSON unpacking functions to retrieve the values and then run AVG on that set. The specific syntax for this action will vary with your database (it might not be possible in your database although most of the big ones support it).