In a note I have 3 properties, each containing a list of numbers:
publish: [ 6, 9, 8, 4 ]
develop: [ 3, 8, 2, 9 ]
admin: [ 7, 3, 9, 12 ]
Is it possible to write a dataview query that shows the mean, or even better the media value for each property as well as the sum of the mean/median values; like this:
| publish | develop | admin | total |
|---|---|---|---|
| 6.8 | 5.5 | 7.8 | 20.1 |
If not with dataview, is there any other possibility to achieve this?