Average function of JSON data

Support Usage Support
1

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.

Снимок экрана 2021-07-23 в 16.45.32
Снимок экрана 2021-07-23 в 16.45.322080×1402 162 KB

2

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

3

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

4

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).